Try this: Set VAR vText TEXT = ',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'' '
INSERT INTO Test01 (t01,t02,t03) values (1245,'N', .vText) Dennis McGrath --- randyp <[EMAIL PROTECTED]> wrote: > Atrix, > > This command works, > INSERT INTO Test01 (t01,t02,t03) values 1245,'N', > ',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'' ' > > This command does not: > INSERT INTO Test01 (t01,t02,t03) values 1245,'N', > ',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'' ' > > My field is 40 characters of text. > > Apparently INSERT will pass only 32 characters to the field -- from > what it > appears to me from the browser. > From the editor I could type the remaining characters in the field. > But the > INSERT command would not pass more. > > Randy Peterson > > > 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 > > > > --- 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. > > ================================================ >
