Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00779805
Message ID:
00779926
Views:
12
>Try storing your statemnt in multiple string variables, then concatenating them in the SQLPREPARE function. Something like this:
>cCmd1 = "select * "
>cCmd2 = "from authors"
>
>liResult = sqlprepare(iHandle, cCmd1 + cCmd2)
>liResult = sqlexec(iHandle)
Or, if your version supports this syntax:
TEXT TO lcCmd
SELECT * 
   FROM authors
ENDTEXT
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform