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)
