Jim, thanks works great Robert Mann
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[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 _______________________________________________ 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
