Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to execute sql statement stores in a string
Message
From
26/07/2001 23:52:00
 
 
To
26/07/2001 23:44:28
Devrishi Bhogra
Escorts Claas Limited
Faridabad, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00536199
Message ID:
00536200
Views:
10
Hi Devrishi,

If you know the command is going to be SELECT, just store the parameters in the property, as in "* FROM anytable".

Then....
cCmdParms=myform.sqlstring
SELECT &cCmdParms
>Hi there!!
>
>i am designing a standard help form for my application with SqlString as a property.
>
>myform.sqlstring = "select * from anytable"
>
>my problem is how can i execute a sqlstatement stored in string.
>
>i tried evaluate() function but that didn't work.
>
>
>
>Regards
>
>Sunny
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform