Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UPDATE - SQL using Form Control Values
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Divers
Thread ID:
01264672
Message ID:
01264852
Vues:
10
I've been meaning to try this technique out, but had some issue the last time I did (maybe referencing form properties). Anyway, I put it in the "later" pile. Now it's later. Thanks for posting this (for the lurkers) and thanks to Bill.

>I got your e-mail - thanks. For the lurkers I'll try to post the code:
>
>local lcSQLCommand
>
>TEXT TO lcSQLCommand textmerge NOSHOW PRETEXT 15
>Update GRADS set
>  cFName = '<<ThisForm.txtcFName.Value >>',
>  cMInit = '<<ThisForm.txtcMInit.Value>>',
>  etc etc..
>endtext
>
>then..
>
>SQLExec(myhandle,lcSQLCommand)
>
>
>Nice idea! Your example seems to be against a SQL backend, whereas my situation is VFP free tables. But, replacing the SQLExec with a macro command-execution ( &lcSQLCommand ) should work just fine.
>
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform