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.
>