HELP: rdoresultset.rowcount doesn't return correct row number 
Author Message
 HELP: rdoresultset.rowcount doesn't return correct row number

rdoresultset.rowcount doesn't always return correct row number.

Sometimes, it returns less row number;
Sometimes, it returns zero incorrectly;
Sometimes, it returns negative number.

Why ?

Anybody knows a walk around ?

Will rdoresultset.movelast help ?

Thanks.

Phil



Sat, 14 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

You will have to do a Resultset.Movelast to get the correct number of rows.
But be careful, this could degrade performance depending on how big your
resultset is.
--
Mike Threlkeld
Technetics Software Development, Inc.
Fayetteville, AR
Please note "anti-spam" e-mail address.



Quote:
> rdoresultset.rowcount doesn't always return correct row number.

> Sometimes, it returns less row number;
> Sometimes, it returns zero incorrectly;
> Sometimes, it returns negative number.

> Why ?

> Anybody knows a walk around ?

> Will rdoresultset.movelast help ?

> Thanks.

> Phil



Sat, 14 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

If you are still havening problems with this just execute a SELECT COUNT(*)
stored procedure/query first. That will give you the exact number and
doesn't take to long to run.  Also movelast does not work on an rdo for
certain result set types!



Quote:
> rdoresultset.rowcount doesn't always return correct row number.

> Sometimes, it returns less row number;
> Sometimes, it returns zero incorrectly;
> Sometimes, it returns negative number.

> Why ?

> Anybody knows a walk around ?

> Will rdoresultset.movelast help ?

> Thanks.

> Phil



Sun, 15 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

...Or, if all you're looking for is to test whether something was returned,
check the EOF property immediately after the query.  It will be True if no
rows were returned, False if one or more rows.

--
Mark Harr
LDA Systems, Inc.

Quote:

>If you are still havening problems with this just execute a SELECT COUNT(*)
>stored procedure/query first. That will give you the exact number and
>doesn't take to long to run.  Also movelast does not work on an rdo for
>certain result set types!



>> rdoresultset.rowcount doesn't always return correct row number.

>> Sometimes, it returns less row number;
>> Sometimes, it returns zero incorrectly;
>> Sometimes, it returns negative number.

>> Why ?

>> Anybody knows a walk around ?

>> Will rdoresultset.movelast help ?

>> Thanks.

>> Phil



Tue, 17 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

Quote:

>rdoresultset.rowcount doesn't always return correct row number.

A suggestion no one has made yet: open your rdoResultset as Static or
Keyset. Then RowCount will be correct, but control won't return to your app
until the resultset is fully populated.


Thu, 26 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

movelast before doing a rowcount

Quote:


>>rdoresultset.rowcount doesn't always return correct row number.

>A suggestion no one has made yet: open your rdoResultset as Static or
>Keyset. Then RowCount will be correct, but control won't return to your app
>until the resultset is fully populated.



Sun, 29 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

If you are using a SQL/ODBC server you can have it tell you what the row
count is.  This way you don't have to populate the entire record set to get
the complete row count.

Quote:

>movelast before doing a rowcount



>>>rdoresultset.rowcount doesn't always return correct row number.

>>A suggestion no one has made yet: open your rdoResultset as Static or
>>Keyset. Then RowCount will be correct, but control won't return to your
app
>>until the resultset is fully populated.



Sun, 29 Oct 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

Only MoveLast returns a true RowCount



Quote:


> >rdoresultset.rowcount doesn't always return correct row number.

> A suggestion no one has made yet: open your rdoResultset as Static or
> Keyset. Then RowCount will be correct, but control won't return to your
app
> until the resultset is fully populated.



Wed, 01 Nov 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

Quote:

>movelast before doing a rowcount



>>>rdoresultset.rowcount doesn't always return correct row number.

>>A suggestion no one has made yet: open your rdoResultset as Static or
>>Keyset. Then RowCount will be correct, but control won't return to your
app
>>until the resultset is fully populated.

MoveLast is not necessary if you open your resultset as Static or Keyset, at
least when your cursor driver is rdUseServer.


Wed, 01 Nov 2000 03:00:00 GMT  
 HELP: rdoresultset.rowcount doesn't return correct row number

Quote:

>Only MoveLast returns a true RowCount

I beg to differ.


Wed, 01 Nov 2000 03:00:00 GMT  
 
 [ 11 post ] 

 Relevant Pages 

1. HELP: rdoresultset.rowcount doesn't return correct row number

2. HELP: rdoresultset.rowcount doesn't return correct row number

3. Help with Rowcount of RdoResultSet

4. GetVolumeInformation doesn't return Serial Number (network drive) under Win98

5. Right Click on Grid doesnt Return Correct Row#

6. Dblist doesn't seem to work correct

7. Clipboard.SetText doesn't set the correct font name

8. Form doesn't show correct

9. WNetGetNetworkInfo doesn't report correct status

10. Inet ftp GET does't return correct file format

11. Can't return correct table values from combobox

12. Building an array to fit the number of rows returned

 

 
Powered by phpBB® Forum Software