OK. The four numbers are for the 4 versions, 7.6, 8.0, 9.0 32 and 9.0 64 Your explanation makes sense. I never could find anything in the help to explain what those limits meant.
I don't think I have ever hit the limits of 100/400 for 7.6 If I did, I probably wondered why the expression wouldn't work and just found another way to do it. Thanks, Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Tuesday, May 11, 2010 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Select items limit Dennis, I don't remember what all four of the numbers mean. number of items and number of bytes are probably two of them. But an "item" is a column, or an operator, or a variable, or a string or a function name or a parenthesis within an expression. So: SELECT CustomerID, + (Lastname + ',' & FirstName & (IFNULL(telephone,'**not on file**',telephone) + FROM people has 1 item for customer, and about 14 "items" for the expression. Bill On Tue, May 11, 2010 at 4:06 PM, Dennis McGrath <[email protected]<mailto:[email protected]>> wrote: Why do I see no answer to this? Maybe no one knows the answer? It looks important. -----Original Message----- I was reading the comparison between the 4 RBASE versions http://www.rbase.com/rbg90/compare.php "SELECT" Items Limit 100 1024 100 1024 Number of Items Accumulated in a SELECT 400 1,024 400 1,024 What do these numbers refer to, i.e. what is an "item" and what is an "accumulated item" I do huge selects all the time with no problem, or at least I thought I had no problem. What happens if these are exceeded? Thanks Dennis McGrath
