Hi Troy,
thanks for the help but all those things are fine.
userappno is integer
Clause is a text 50
approval is text 1
in the sql that errored i was inserting:
userappno:1245
approval: N
Clause: ,'1','2','3','4','5','6','7','8','9')
so that gives the sql of (properly sql encoding Clause):
insert into AcctPriv (UserAppno,approval,Clause) values
1245,'N',',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')'
which is giving me an error
-ERROR- Insufficient space to process INSERT command
Dennis duplicated my problem and said this is something hes known about for
years ):
check out the command file he attached in his last post if you want to see
the problem duplicated.
----- Original Message -----
From: "Troy Sosamon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, August 08, 2003 9:00 AM
Subject: [RBASE-L] - Re: SQL problem
> Atrix,
>
> So you are still having problem with your insert from Tango?
>
> Make sure you are using a direct dbms command.
> Make sure you are not inserting into any computed or autonumbered columns.
>
> You can't use the extra flags like the NONUM flag on the LOAD command.
>
> This statement has some problems:
> >insert into AcctPriv (UserAppno,approval,Clause) values
> > > 1245,'N',',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')'
>
> The number and type of values have to match the columns.
>
> insert into acctpriv (userappno, apporval, clause) values ('1245', 'N',
'1')
>
> Troy
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Atrix
> Wolfe
> Sent: Friday, August 08, 2003 9:46 AM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Re: SQL problem
>
>
> I wish that would help but as im using r:tango i dont think i have that
> option ):
>
> ----- Original Message -----
> From: "Dennis McGrath" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Friday, August 08, 2003 5:21 AM
> Subject: [RBASE-L] - Re: SQL problem
>
>
> > Atrix,
> >
> > I'm attaching a short file. I duplicated your insert but added parens
> > around the value list. I got "Insufficient memory" error.
> >
> > The I tried putting the string into a variable and used that in my
> > insert and it worked perfectly.
> >
> > Over the years I have had to resort to this kind of thing to get around
> > this problem when inserting text with embedded quotes or parens. It's
> > nothing new.
> >
> > Dennis McGrath
> >
> >
> >
> >
> > --- Atrix Wolfe <[EMAIL PROTECTED]> wrote:
> > > Hi List,
> > >
> > > Im sure the problem is a user (me!) issue but can anyone see anything
> > > wrong
> > > with this insert statement?
> > >
> > > insert into AcctPriv (UserAppno,approval,Clause) values
> > > 1245,'N',',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')'
> > >
> > > im getting the error message:
> > >
> > > -ERROR- Insufficient space to process INSERT command
> > >
> > > Clause is text 50 so that should be enough to handle it, userappno is
> > > integer and approval is text 1 so i dont think its either of those in
> > > error.
> > >
> > > im trying to insert this text into that table:
> > > ,'1','2','3','4','5','6','7','8','9')
> > >
> > > Thanks for the help!
> > > Atrix
> > >
> >
> >
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > create temp table AcctPriv (UserAppno int,approval text (1),Clause TEXT
> (40))
> >
> > insert into AcctPriv (UserAppno,approval,Clause) values +
> > (1245,'N',',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')')
> >
> > set var vText TEXT =
> ',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')'
> > write .vtext
> >
> > insert into AcctPriv (UserAppno,approval,Clause) values +
> > (1245,'N',.vtext)
>
