Page 1 of 1

Table refresh

Posted: Wed 11 Nov 2009 12:56
by belidzs
hi,

is there any built-in function to refresh a datatable? I am currently using close/open sequence, but it changes the position of the current record and also costs a lot of time to load.
I would also need a method which refreshes only one record of a table. RefreshRow is nice to have, but unfortunately it cannot refresh the table if there is another related to it. Now I have to make a change in the table, update the dataset, and use RETURNING values to get the changes from a row. If there is any other viable solution, please let me know!

thanks,
Balazs

Posted: Thu 12 Nov 2009 11:55
by AndreyR
Take a look at the PgSqlDataTable.RefreshMode property. It makes refresh of the row
after the insert and/or update is performed.
As for the refreshing of the whole DataTable, Open/Close is an acceptable way.