Atrix, The value portion of your insert needs to be enclosed in parens. Also; since you're working with reserved(?) characters it might be easiest to build a variable and use in the insert. Just adding the parens might do the job... but I get confused when trying to balance escaped characters; and embedded parens have given me grief also.
Set v vD Text = (char(39) + char(44) + char(39)) Set v vClause Text = (char(44)+'1'.vD+'2'+.vD+....'9'+char(39)+char(41)) (if you "sho v vclause" at the R> it should look like the string you're trying to insert) Insert into AcctPriv (UserAppno,approval,Clause) + values + (1245,'N',.vClause) Ben Petersen On 6 Aug 2003, at 23:04, Atrix Wolfe 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 >
