Randy, syntax calls for parens around the inserted values. I would also try something
slightly different.
SET VAR vt03 = ('1,2,3,4,5,6,7,8,9')
INSERT INTO Test01 (t01,t02,t03) VALUES (1245,'N',.vt03)
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.
>> ================================================
>
>
--
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32
__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397
Get AOL Instant Messenger 5.1 free of charge. Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
