Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

100 row rdoresults set limit?

6 views
Skip to first unread message

Erez Wolf

unread,
Oct 14, 1997, 3:00:00 AM10/14/97
to

Never Mind... I solved the problem.. Had to do with the code in the
UnboundReadData event of the Sheridan Datagrid...

Thanks..


Erez Wolf

unread,
Oct 14, 1997, 3:00:00 AM10/14/97
to

I have created and rdoresultset and can't get more than 100 rows in
the rs. I am using an intersolv ODBC driver to talk to Sybase System
11. I tried the MS SQLServer ODBC driver and had the same problem.

I found some references in the Help to the RowSetSize property, but
I'm not using a RDO Database Control. I tried to convert my
CreateRDOResultset to a RDOQuery definition, but get the same thing.

Evaluating the MoreResults property didn't work as well.

When issuing the query in Access through Jet, I get 105 rows, so I
know there is more data.

I am trying to load the data into a Sheridan Data Grid (2.0) using
unbound mode, but when issuing a movelast, I only get 100 rows.

Anyone have any ideas?

TIA
Erez Wolf
erez...@cybercom-intl.com

Maciej Wojtkowiak

unread,
Oct 15, 1997, 3:00:00 AM10/15/97
to

Try set MaxRows property

Erez Wolf wrote in message <34448cf8....@news.supernews.com>...

Christer Romson

unread,
Oct 15, 1997, 3:00:00 AM10/15/97
to

You ought to get all rows, so there's probably a bug somewhere. Have you =
tried using the rdoQueries (or rdoPreparedStatements)? They also have =
Rowsetsize and keysetsize properties. These default to 100 rows. So what =
you're experiencing is probably that rdo gets the first set of rows and =
then your bug hits when you move past the 100st row. In you situation =
I'd try setting rowsetsize and keysetsize to zero.=20

You may want to check what odbc calls rdo issues to see if this is a bug =
in rdo or the odbc driver.=20

Christer Romson

Erez Wolf:


> I have created and rdoresultset and can't get more than 100 rows in
> the rs. I am using an intersolv ODBC driver to talk to Sybase System
> 11. I tried the MS SQLServer ODBC driver and had the same problem.

>=20


> I found some references in the Help to the RowSetSize property, but
> I'm not using a RDO Database Control. I tried to convert my
> CreateRDOResultset to a RDOQuery definition, but get the same thing.

>=20


> Evaluating the MoreResults property didn't work as well.

>=20


> When issuing the query in Access through Jet, I get 105 rows, so I
> know there is more data.

>=20


> I am trying to load the data into a Sheridan Data Grid (2.0) using
> unbound mode, but when issuing a movelast, I only get 100 rows.

>=20
> Anyone have any ideas?
>=20
> TIA
> Erez Wolf
> erez...@cybercom-intl.com
>

0 new messages