Update only one record

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ben
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Update only one record

Post by ben » Wed 14 Sep 2005 23:50

Hello, I have a table that displays 1000 records, and I have changed only one record (using a TQuery). How can I update only this record without refreshing all 1000 records (the entire table) ?

ben
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Post by ben » Wed 14 Sep 2005 23:59

Btw, I know about "RefreshRecord" but this affect the current/selected record. I want to refresh another record, wihout using Locate.

alec
Posts: 20
Joined: Wed 24 Aug 2005 09:28
Location: Africa

Post by alec » Thu 15 Sep 2005 03:16

see MyDAC manual:
TMyQuery::RefreshQuick method

ben
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Post by ben » Thu 15 Sep 2005 08:40

there is no reference about RefreshQuick in the mydac.hlp file

alec
Posts: 20
Joined: Wed 24 Aug 2005 09:28
Location: Africa

Post by alec » Thu 15 Sep 2005 10:16

ben wrote:there is no reference about RefreshQuick in the mydac.hlp file
MyDac 4+

ben
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Post by ben » Thu 15 Sep 2005 18:33

oh yes, i already have 4+ but i was looking on old file. Any example please? Help is just theory :D

vvitolo
Posts: 10
Joined: Fri 26 Aug 2005 21:45
Location: S/C de Tenerife

Post by vvitolo » Sun 18 Sep 2005 09:11

hi,
you can try to see MyDAC manual:
TMyTable::Options::CheckRowVersion &
TMyTable::RefreshOptions.

Post Reply