Print Thread
HOWTO: Get only some rows
#90 10/15/99 10:00 PM
Joined: Oct 1999
Posts: 1
Vienna, Austria
M
Member
OP Offline
Member
M
Joined: Oct 1999
Posts: 1
Vienna, Austria
I'm searching for a way to retrieve only the first X rows after a select statement has been started as soon as possible and display them in a data grid.

In the Borland BDE is parameter ROWSET SIZE which delimits the amount of transferred rows to the value of this parameter. How can something similar be done with DOA?

There must be a way to do this because in the PL/SQL Developer of AllroundAutomations I get this desired behaviour after starting a select statement in a SQL window: a grid opens and is filled constantly (you even see how many rows are transfered and are able to break this transfer).

Michael

Re: HOWTO: Get only some rows
#91 10/18/99 12:28 PM
Joined: Sep 1999
Posts: 11
H
Member
Offline
Member
H
Joined: Sep 1999
Posts: 11
Michael,

set the "QueryAllRecords" property ot the OracleDataset to FALSE

Holger


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.029s Queries: 12 (0.007s) Memory: 2.4987 MB (Peak: 3.0418 MB) Data Comp: Off Server Time: 2024-05-13 22:01:01 UTC
Valid HTML 5 and Valid CSS