sql update statement

[Robert Mann]

Jim,
thanks works great

Robert Mann


-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Jim Ault
Sent: Sunday, October 01, 2006 10:43 AM
To: How to use Revolution
Subject: Re: sql update statement


   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" <robmann at gp-racing.com> 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
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution