Now that DID work, truly amazing (:
something of interest here though is that when i reported the bug, i put the
sql statement i was trying to do within the form on the web and when i
submitted it, i hit the very error i was trying to report.
So, maybe this is a case of parenthesis not getting properly sql encoded, or
maybe certain syntax of insert isnt taken correctly in certain situations.
kinda interesting.
----- Original Message -----
From: "Dennis McGrath" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, August 08, 2003 3:16 PM
Subject: [RBASE-L] - Re: SQL problem
> It may be the embedded paren that is being misintepreted. Try this:
>
> insert into AcctPriv (UserAppno,approval,Clause) values
> ( 1245,'N',(',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9''' +
> ')'))
>
> Notice I have put the parens around the list per Bill, as I agree, but
> I have also parenthesised the problem string itself, and separated out
> the desired parenthesis and concatenated it.
>
> Test this in an RBase command file to debug it completely before trying
> to pass it off to tango.
>
> Dennis McGrath
>
>
>
>
> --- Bill Downall <[EMAIL PROTECTED]> wrote:
> > 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
> >
>
