You need brackets around the range of values: insert into AcctPriv (UserAppno, approval, Clause) values ( 1245, 'N', ',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')' )
Regards, Alastair. ----- Original Message ----- From: "Atrix Wolfe" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 07, 2003 7:04 AM Subject: [RBASE-L] - SQL problem > 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 > > --- RBASE-L > ================================================ > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [EMAIL PROTECTED] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message SUBJECT, put just one word: INTRO > ================================================ > TO UNSUBSCRIBE: > Send a plain text email to [EMAIL PROTECTED] > In the message SUBJECT, put just one word: UNSUBSCRIBE > ================================================ > TO SEARCH ARCHIVES: > Send a plain text email to [EMAIL PROTECTED] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > ================================================ >
