sql update statement

Jim Ault JimAultWins at yahoo.com
Sun Oct 1 10:42:44 CDT 2006


   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
> 





More information about the use-livecode mailing list