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)
