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
>
