thanks for the work around (: its not mission critical so im not real worried about it at the moment.
just wanted to share so it could be resolved in case it became mission critical for myself or anyone else. ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 9:45 AM Subject: [RBASE-L] - Re: SQL problem > 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) > > >
