the exact text im trying to insert is this:
,'1','2','3','4','5','6','7','8','9')
it may look strange but thats because its a peice of an sql statement.
Maybe ill report this as a bug and see what comes of it.
Thanks for the help!
Atrix
----- Original Message -----
From: "Albert Berry" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, August 07, 2003 5:29 AM
Subject: [RBASE-L] - Re: SQL problem
> 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
>
