That was truly a head scratcher, Atrix. Glad I could come up with the
work around.
Dennis McGrath
--- Atrix Wolfe <[EMAIL PROTECTED]> wrote:
> 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
> > >
> >
>
