Print Thread
RecordNumber function?
#61004 02/16/20 04:47 PM
Joined: Mar 2010
Posts: 14
H
Member
OP Offline
Member
H
Joined: Mar 2010
Posts: 14
Migrating BDE application I find that there seems to be no "RecordNumber" function equivalent for TOracleDataset.
We look for the position counter of all records read (so far).
E.g the query reads 50 records (RecordNumber is 1), user does click on TDBNavigator-next 3 times and then RecordNumber is 4.

BTW: is it planned to have a DOA Users Guide with index (as we have it for PL/SQL Developer?)

Re: RecordNumber function?
hollowb7 #61006 02/17/20 10:37 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You can use TOracleDataSet.RecNo. It returns the current record number (1..N) of the dataset.


Marco Kalter
Allround Automations
Re: RecordNumber function?
Marco Kalter #61250 03/14/20 05:53 PM
Joined: Mar 2010
Posts: 14
H
Member
OP Offline
Member
H
Joined: Mar 2010
Posts: 14
thanks - that works!


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.165s Queries: 14 (0.034s) Memory: 2.5039 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-19 09:14:36 UTC
Valid HTML 5 and Valid CSS