Try inserting the userappno and then use an update command to put the clause in.
Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Atrix Wolfe Sent: Friday, August 08, 2003 10:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL problem 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) >
