Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FoxPro / Setup / November 2003

Tip: Looking for answers? Try searching our database.

Intellisense

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bilal - 20 Nov 2003 10:35 GMT
I am using this code in the Intellisense. It works fines
but it also dispalys the error: FOXCODE SCRIPT " FAILURE.
Any idea??

********************
LPARAMETER oFoxCode
lcExec=Inputbox("Type SQL Statment :")
h=sqlstringconnect("driver=SQL
Server;server=MyServerName ;uid=UserName;pwd=PassWord;datab
ase=MyDataBase")
sqlexec(h, lcExec, "xyz")
sqldisconnect(h)
********************
Fred Taylor - 20 Nov 2003 15:26 GMT
If you were to have a table open in the 8th woek area (area "h"), you may be
conflicting with your single letter variable "h".  Try changing your
variable name to at least 2 letters and see if that helps.

It's not a good idea to use single letter variable names a-j and m, as
that's the old style area reference to the old style first 10 work areas,
and to memory variables.

Fred
Microsoft Visual FoxPro MVP

> I am using this code in the Intellisense. It works fines
> but it also dispalys the error: FOXCODE SCRIPT " FAILURE.
[quoted text clipped - 9 lines]
> sqldisconnect(h)
> ********************
Bilal - 21 Nov 2003 07:20 GMT
Hi Fred, I tried your suggestion, but I keep getting the
same error.
Thanks

>-----Original Message-----
>If you were to have a table open in the 8th woek area (area "h"), you may be
[quoted text clipped - 16 lines]
>> lcExec=Inputbox("Type SQL Statment :")
>> h=sqlstringconnect("driver=SQL

Server;server=MyServerName ;uid=UserName;pwd=PassWord;datab
>> ase=MyDataBase")
>> sqlexec(h, lcExec, "xyz")
>> sqldisconnect(h)
>> ********************
>
>.
Randy Brown - 21 Nov 2003 17:49 GMT
Try adding a RETURN "" at the end.

Randy

I am using this code in the Intellisense. It works fines
but it also dispalys the error: FOXCODE SCRIPT " FAILURE.
Any idea??

********************
LPARAMETER oFoxCode
lcExec=Inputbox("Type SQL Statment :")
h=sqlstringconnect("driver=SQL
Server;server=MyServerName ;uid=UserName;pwd=PassWord;datab
ase=MyDataBase")
sqlexec(h, lcExec, "xyz")
sqldisconnect(h)
********************
Mike Pratt - 21 Nov 2003 21:05 GMT
Could those semi-colons be messing you up? They are, after all, VFP's
line continuation character.

Regards,

Mike

>I am using this code in the Intellisense. It works fines
>but it also dispalys the error: FOXCODE SCRIPT " FAILURE.
[quoted text clipped - 9 lines]
>sqldisconnect(h)
>********************
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.