Update only one record

Update only one record

Postby 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

Postby 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.
ben
 
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Postby alec » Thu 15 Sep 2005 03:16

see MyDAC manual:
TMyQuery::RefreshQuick method
alec
 
Posts: 20
Joined: Wed 24 Aug 2005 09:28
Location: Africa

Postby ben » Thu 15 Sep 2005 08:40

there is no reference about RefreshQuick in the mydac.hlp file
ben
 
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Postby alec » Thu 15 Sep 2005 10:16

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

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

Postby 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
ben
 
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Postby vvitolo » Sun 18 Sep 2005 09:11

hi,
you can try to see MyDAC manual:
TMyTable::Options::CheckRowVersion &
TMyTable::RefreshOptions.
vvitolo
 
Posts: 10
Joined: Fri 26 Aug 2005 21:45
Location: S/C de Tenerife


Return to MySQL Data Access Components