Limiting selected ercords

[umayr]

Hi

Is there are way that I can use the DOA components to Limit the 'select' records.

Q1) eg : select * .. from table limit x;

I have a form with a grid, and several lookup (combo) components. This form takes a long time to load. It retrieves
i) All lookup records to fill combo data
ii) main table data.

Q2) Any hints on how I could improve the load performance. I have set the 'Table.Loadallrecords' to false.

Thanks in Advance.
UShaf

 

[Marco Kalter]

To limit the records that are initially fetched, you can set TOracleDataSet.QueryAllRecords to False. You can also use an expression like 'where rownum