Hello, listers!
I’d love to hear from those of you, that had to do something to work around the 5000 rows limitation
in BO. Any solutions, ideas?
I have got a report that will return more than 5000 different rows in a short time. And it will grow…
I have no idea how to deal with it, so far…
Ryszard Mikke
PS. Pointings to manuals are, of course welcome 
Listserv Archives (BOB member since 2002-06-25)
Open the Univers in Designer. Select Parameters from the file menu. On the Controls Tab change the max number of rows.
hans
I’d love to hear from those of you, that had to do something to work around
the 5000 rows limitation
in BO. Any solutions, ideas?
Listserv Archives (BOB member since 2002-06-25)
On Friday 2 October 1998 Ryszard Mikke wrote:
I’d love to hear from those of you, that had to do something to work
around the 5000 rows limitation in BO.
Any solutions, ideas?
I have got a report that will return more than 5000 different rows in a
short time. And it will grow…
I have no idea how to deal with it, so far…
You can change the default limit for the universe under File / Parameters / Controls tab using the Designer.
Another method, which is very handy, is to copy the SQL code generated by the query and run it using Free-Hand SQL.
Lorenzo Escalante, Jr.
BHP IT Perth, Western Australia
escalante.lorenzo.lj@bhp.com.au
Listserv Archives (BOB member since 2002-06-25)
Hi!
From:
hans.kingma@UNISOURCE-UCS.COM[SMTP:hans.kingma@UNISOURCE-UCS.COM]
Open the Univers in Designer. Select Parameters from the file menu. On the Controls Tab change the max number of rows.
Umm… Hmm…
First of all: Thanks, that works!
But then, what is the meaning of ‘Maximum Number of Rows Fetched’ option in Database tab
of Tools->Options in Designer, which has a fixed limi of 10k (in 4.1.2a, which I use now,
in version 4.1.1 that I have been using two weeks ago it was 5k - hence the subject 
).
Curious,
Ryszard Mikke
Listserv Archives (BOB member since 2002-06-25)
Mikke Ryszard wrote:
But then, what is the meaning of ‘Maximum Number of Rows Fetched’
option in
Database tab
of Tools->Options in Designer, which has a fixed limi of 10k (in
4.1.2a,
which I use now
That’s the maximum number of rows fetched when you want to see what records are present in a table or what values a column has (right mouse click, values) on the table or on a column in the structure window in designer (I use the default of 100 rows, that’s usually indication enough).
Succes,
Marianne Wagt
IDETA, the Netherlands
Listserv Archives (BOB member since 2002-06-25)