Connection Problem

[rinoshjoseph]

Hello,
I use TOracleDataset to connect a database table and a dbGrid.(ie 'select a.rowid, a.* from obj_table a' ) The doubt is after calling the .open if I execute an update statement for this table using an SQL(Update table ...) in another transaction , how the dataset gets refreshed and the performance of update sql

Regards
Rinosh

 

[Marco Kalter]

There are a few options:
[*] Refresh the TOracleDataSet.

[*] Locate the record(s) you updated in the dataset, and call RefreshRecord.

[*] Include roAfterEdit in TOracleDataSet.RefreshOptions. Now the updated record will be refreshed when a user starts to edit it.[/list]

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