put "'" into p -- < don't forget this
get "2srd3 = " &p& fld 2srd3 &p
get it & ",2srd4 = " &p& fld 2srd4 &p
get it & ",2srd5 = " &p& fld 2srd5 &p
get it & ",2srd5 = " &p& fld 2srd5 &p
get it & ", srideht = " &p& fld srideht &p
get it & ", smisccomment = " &p& fld smisccomment &p
put it into updateColValListOf123Pairs
put "UPDATE rider SET "&updateColValListOf123Pairs&" WHERE record_id
= '" & fld "record_id" & "'" into tSQL
revExecuteSQL dbID2,tSQL
Jim Ault
Las Vegas
On 10/1/06 5:20 AM, "Robert Mann" <[EMAIL PROTECTED]> wrote:
> Thanks so much but how do I set up the following SQL statement using your
> example
>
> get "2srd3 = " &p& fld 2srd3 &p
> get it & ",2srd4 = " &p& fld 2srd4 &p
> get it & ",2srd5 = " &p& fld 2srd5 &p
> get it & ",2srd5 = " &p& fld 2srd5 &p
> get it & ", srideht = " &p& fld srideht &p
> get it & ", smisccomment = " &p& fld smisccomment &p
> put it into updateColValListOf123Pairs
>
>
> put "UPDATE rider SET updateColValListOf123Pairs WHERE record_id
> = '" & fld "record_id" & "'" into tSQL
> revExecuteSQL dbID2,tSQL
>
>
>
> Robert Mann
>
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
