how could I resync a simple row in large query result ?

ziclope · Post by **ziclope** » Mon 03 Apr 2006 19:15

Hello,

With ADO exists Recordset->Resync method for syncronize a simple row in query result. With MyDAC is possible ?

What is the best way for do it ?

Regards

swierzbicki · Post by **swierzbicki** » Tue 04 Apr 2006 06:58

I don't know how the Resync method is working but have you tried the MyQuery.RefreshRecord method ? (RefreshRecord will refresh the current row, all modification will be lost).

Antaeus · Post by **Antaeus** » Tue 04 Apr 2006 09:44

ziclope, procedure Resync() also persists in MyDAC. Please specify for what reasons do you want to use it. Maybe RefreshRecord or RefreshQuick will be more useful for you.

ziclope · Post by **ziclope** » Tue 04 Apr 2006 18:51

Exists any example of RefreshQuick ?

I don´t undestand how it works. I need TimeStamp for each table ?
It is a calculated field ?

Regards

Antaeus · Post by **Antaeus** » Wed 05 Apr 2006 09:40

This function is inherited from TDataSet without changes. Therefore you can know more about this function in C++Builder or Delphi help.

ziclope · Post by **ziclope** » Wed 05 Apr 2006 14:11

how ?

RefreshQuick is inherited from TDataSet ?
Please, read the post again.

Read

Antaeus · Post by **Antaeus** » Thu 06 Apr 2006 12:47

I meant Resync function in my previous post.
We don't have such example with RefreshQuick function. To use RefreshQuick you should request from each table key field(s) and field with TIMESTAMP data type. TIMESTAMP is special data type that is managed automatically so you shouldn't set any value to it.