Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE - SQL using Form Control Values
Message
 
To
29/10/2007 13:48:16
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Miscellaneous
Thread ID:
01264672
Message ID:
01264852
Views:
9
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
Previous
Reply
Map
View

Click here to load this message in the networking platform