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
Atrix;
Use the following syntax to properly achieve your goal:
===================================================================
CREATE TEMP TABLE AcctPriv (UserAppno INTEGER,approval TEXT (1),Clause TEXT (40))
SET QUOTES = "
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)
SET QUOTES = ' ===================================================================
That is the simple solution. The more complex solution is to create a variable where you
imbed (CVAL('QUOTES')) functions, but why make it more difficult than it needs to be.
Best Regards,
Mike
