Re: msql insert new record

2006-10-22 Thread Jim Ault
On 10/22/06 4:40 PM, "Robert Mann" <[EMAIL PROTECTED]> wrote: > I have put all my table names into > colnames each separated by a , > > I have also put all new values into colvalues each separated by a , > > can someone tell me the proper format for the following insert statement for > RR > > p

RE: msql insert new record

2006-10-22 Thread Robert Mann
s Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday, October 15, 2006 8:16 PM To: How to use Revolution Subject: Re: msql insert new record On 10/15/06 4:14 PM, "Robert Mann" <[EMAIL PROTECTED]> wrote: >

Re: msql insert new record

2006-10-16 Thread Josh Mellicker
quot; put it into colvalues put "INSERT INTO rider "colnames" VALUES "colvalues"" into tSQL Thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday, October 15, 2006 8:16 PM To: How to use R

RE: msql insert new record

2006-10-16 Thread Robert Mann
Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday, October 15, 2006 8:16 PM To: How to use Revolution Subject: Re: msql insert new record On 10/15/06 4:14 PM, "Robert Mann" <[EMAIL PROTECTED]> wrote: >

Re: msql insert new record

2006-10-15 Thread Jim Ault
On 10/15/06 4:14 PM, "Robert Mann" <[EMAIL PROTECTED]> wrote: > have a update code that works great, with some held form this list > > put "UPDATE rider SET "&updateColValListOf123Pairs&" WHERE record_id = '" & > fld "record_id" & "'" into tSQL > > how would I change this to insert a new record

msql insert new record

2006-10-15 Thread Robert Mann
have a update code that works great, with some held form this list put "UPDATE rider SET "&updateColValListOf123Pairs&" WHERE record_id = '" & fld "record_id" & "'" into tSQL how would I change this to insert a new record get "fcomp = " &'& fld fcomp &' get it & ",freb = " &'& fld freb &' get