Rows Processed Count From TOracleDataSet

[geraldwinslow]

I am trying to determine the rows processed count by the SQL statement I pass to and execute from a TOracleDataSet control. There doesn't seem to be a built-in property or method that gives that information.

Does anyone know of a way to get that data? What I want is the control to tell me how many rows were returned by a Select and how many rows were processed by a Delete, Insert or Update.

Any ideas?

Thanks,
Gerald Winslow

 

[F.Hinlopen]

As a TDataSet descendant, TOracleDataSet implements the RecordCount property. When using TOracleQuery, use the RowsProcessed function.
HTH.

Originally posted by geraldwinslow:
I am trying to determine the rows processed count by the SQL statement I pass to and execute from a TOracleDataSet control. There doesn't seem to be a built-in property or method that gives that information.

Does anyone know of a way to get that data? What I want is the control to tell me how many rows were returned by a Select and how many rows were processed by a Delete, Insert or Update.

Any ideas?

Thanks,
Gerald Winslow

------------------
Frans

 

[geraldwinslow]

I tried using RecordCount, and while it works great for SQL statements that are SELECTs, it does not work for non-queries. For instance, for an UPDATE, RecordCount=0. That's not what I want. In the case of an UPDATE (for instance), I want the control to tell me how many rows were UPDATEd.

 

[Marco Kalter]

The TOracleDataSet does not have such a property. Perhaps you can use a TOracleQuery and check the RowsProcessed property?

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