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)
