i tried adding the parens around to no avail, still get the error ): ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 9:31 AM Subject: [RBASE-L] - Re: SQL problem
> On Fri, 8 Aug 2003 09:05:50 -0700, Atrix Wolfe wrote: > > >insert into AcctPriv (UserAppno,approval,Clause) values > >1245,'N',',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')' > > You still need parens around your whole list of values. The syntax for insert > says it should be: INSERT INTO table (columnlist) VALUES (valuelist) > > insert into AcctPriv (UserAppno,approval,Clause) values > ( 1245,'N',',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')' ) > > Bill > >
