Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building a SQL statement on the fly
Message
 
To
10/09/1999 22:44:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00263324
Message ID:
00263938
Views:
30
>Hi William,
>
>Since you're interested in what others have done... I ran into the same problem when building SQL statement on the fly to use in SPT. What I did to work around was use STRTOFILE() to gather all of the syntax, and then FILETOSTR() when I passed it to SQL. Worked for me.
>
>Take Care
>

This seems like the easiest approach, Thanks. You look at something and know there is a better way but just can't see it... Unfortunately, this project is done in VFP 5, but I can implement the STRTOFILE and FILETOSTR functions pretty easy using fcreate, fopen, fputs, and fclose commands. Hi ho, hi ho, its off to code I go......
Oct 31 = Dec 25
Previous
Reply
Map
View

Click here to load this message in the networking platform