Hello,

I have retrieved a bunch of record from an Oracle query I need to locate a specific record by on field and retrieve the value of another field in the same record. If I was using the OracleDataset component I could use the standard Dataset.Locate function.

Is there an equivalent method or function I can use on the OracleQuery component - other than looping through all of the fields in the resultset?

Thanks

There is no Locate or SearchRecord equivalent for a TOracleQuery. Note that this is just a low-level encapsulation of an Oracle Cursor, and as you probably know, in a cursor you can just look at the current record and fetch the next one.

The best alternative is probably a select statement with an appropriate where clause.

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