Empty results with TOracleDataset

[nboodram]

Hello,

I am using a TOracleDataset whose SQL.Text property is set to a select SQL statement. When I run the statement in SQL Plus I get 188 rows. When I open the dataset in my code, RecordCount is 0, EOF and BOF are both True. Using OracleMonitor, I see the following for my dataset's MainQuery:

Query.Execute (25 records processed) Query.Next for up to 25 records (25 records processed)
Query.Next for up to 25 records (21 records processed)

Does that mean it retrieved 71 records? Then why is my dataset in Delphi empty? What am I missing here?

Thanks,
Natalie

 

[Marco Kalter]

Yes, the dataset has fetched 71 records and the query is finished. RecordCount should also be 71, unless you have defined a Filter.

------------------
Marco Kalter
Allround Automations

 

[nboodram]

Thank you for your response. It was an error on my part-- I forgot to clear my filter.