OraQuery.Last not working properly
Posted: Thu 17 Oct 2019 11:49
ODAC 11.0.1
Record count in my test table: 179
OraQuery properties:
FetchAll = False
FetchRows = 25
First step: Open - OK
Second step: Last command (It doesn't matter if I'm using dbNavigator or executing the Last command in the code)
Effect: All navigation buttons are gray. The record is empty. The cursor is outside EoF (?). When I use CRDBGrid in the footer I see 0/179. When I set FetchAll to true, everything works fine, but I can't do it because the tables have millions of records in the end
Record count in my test table: 179
OraQuery properties:
FetchAll = False
FetchRows = 25
First step: Open - OK
Second step: Last command (It doesn't matter if I'm using dbNavigator or executing the Last command in the code)
Effect: All navigation buttons are gray. The record is empty. The cursor is outside EoF (?). When I use CRDBGrid in the footer I see 0/179. When I set FetchAll to true, everything works fine, but I can't do it because the tables have millions of records in the end