QueryAllRecords

[Federico]

Hi to everybody. First of all sorry for my English.
I try to explain my problem:
I have Delphi 5 and a TOracleDataSet with QueryAllRecords := TRUE. When i open it and use Locate or SerchRecord to find a particular record i don't get it. The problem is that the TOracleDataSet not returns all records (the table is 400 and i get recordcount = 65) so i don't find some record. I think i need all records to use locate or searchRecord. How can i obtain all records?
thanks

 

[Marco Kalter]

If you get 65 records, then either the table contains no more than 65 records, or you have applied a where clause or QBE criteria that limits the result set. You can use the TOracleDataSet.Debug property to determine which SQL is being executed.

 

[Federico]

ok thank you!