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)
>********************