Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to execute sql statement stores in a string
Message
De
26/07/2001 23:52:00
 
 
À
26/07/2001 23:44:28
Devrishi Bhogra
Escorts Claas Limited
Faridabad, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00536199
Message ID:
00536200
Vues:
9
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform