Hi Albert,
Even limiting the record set to 1 returns the same error.
Thanks,
Ben Petersen
On 6 Jun 2002, at 8:45, Albert Berry wrote:
> Try running the report with a restricted data set. We have had problems with "smily
>faces" in data rows that caused no problems until the specific row of data was read,
>when it caused strange problems.
>
> Will the report print WHERE LIMIT = 10?
>
>
> "Ben Petersen" <[EMAIL PROTECTED]> wrote:
>
> >Javier,
> >
> >Thanks. But there are no punctuation or syntax problems. �To add
> >to the mystery, using another customer's database (same
> >structure) and the same cmd files on the same computer (mine)
> >the report printed fine. Ah Ha! Bad report... nope �:( � � �Loaded the
> >report from the DB where the report printed OK to the problem DB
> >w/o success.
> >
> >Autochk reports no errors, but I'll dig deeper for a possible data
> >problem???
> >
> >Thanks again,
> >
> >Ben Petersen
> >
> >
> >On 4 Jun 2002, at 20:32, Javier Valencia wrote:
> >
> >> I run into the same problem. Check you expression and make sure that:
> >> 1. Parenthesis are balanced. It seems that sometime you do not get an error
> >> message and Rbase thinks you have a huge expression.
> >> 2. Quotes (' or ") used in the expressions match the database settings
> >> It solved the problem for me; good luck
> >>
> >> Javier Valencia, PE
> >> President
> >> Valencia Technology Group, L.L.C.
> >> 14315 S. Twilight Ln., Suite #14
> >> Olathe, KS �66062-4571
> >> (913)829-0888
> >> (913)649-2904 FAX
> >>
> >> -----Original Message-----
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> >> Behalf Of Ben Petersen
> >> Sent: Tuesday, June 04, 2002 12:14 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: Insufficient expression space or too many expressions
> >>
> >> Hi All,
> >>
> >> I have two similar reports based on the same view. One works fine,
> >> the other returns the error "Insufficient expression space or too
> >> many expressions". Both were working recently. I did make some
> >> changes to the view recently, but you can select from it just fine,
> >> and as I said, the other report works OK.
> >>
> >> There are 11 expressions in the report, 2 of which are look-ups.
> >> The report that works has 7 simple expressions.
> >>
> >> Any ideas?
> >>
> >> Thanks,
> >>
> >> Ben Petersen
> >> ================================================
> >> TO SEE MESSAGE POSTING GUIDELINES:
> >> Send a plain text email to [EMAIL PROTECTED]
> >> In the message body, put just two words: INTRO rbase-l
> >> ================================================
> >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> >> In the message body, put just two words: UNSUBSCRIBE rbase-l
> >> ================================================
> >> TO SEARCH ARCHIVES:
> >> http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >>
> >> ================================================
> >> TO SEE MESSAGE POSTING GUIDELINES:
> >> Send a plain text email to [EMAIL PROTECTED]
> >> In the message body, put just two words: INTRO rbase-l
> >> ================================================
> >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> >> In the message body, put just two words: UNSUBSCRIBE rbase-l
> >> ================================================
> >> TO SEARCH ARCHIVES:
> >> http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >>
> >
> >
> >================================================
> >TO SEE MESSAGE POSTING GUIDELINES:
> >Send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: INTRO rbase-l
> >================================================
> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: UNSUBSCRIBE rbase-l
> >================================================
> >TO SEARCH ARCHIVES:
> >http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
>
>
> __________________________________________________________________
> Your favorite stores, helpful shopping tools and great gift ideas. Experience the
>convenience of
buying online with Shop@Netscape! http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at
>http://webmail.netscape.com/
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
