How to update table timestamps without closing programme

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
NoComprende
Posts: 135
Joined: Tue 09 Jan 2007 13:44

How to update table timestamps without closing programme

Post by NoComprende » Wed 31 Mar 2010 09:03

Hi, within my application I've written code to back up only those tables in my database that have been changed. I'm only using MyISAM tables and I'm not using any cached updates on the TMyQuery or TMyTable components I'm using to make the changes. I've found I've got to close down the programme and restart it for the backup code to work as otherwise the timestamps don't change. In fact, after deleting some records, I had to reboot the machine to update the table timestamps.

I'm aware this may be nothing to do with the MyDAC components but can anyone tell me how to get MySQL to update the timestamps on any changed tables?

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 31 Mar 2010 10:19

MySQL server updates timestamp fields on every record updating.
Please give a more detailed description of the problem.

NoComprende
Posts: 135
Joined: Tue 09 Jan 2007 13:44

Post by NoComprende » Wed 31 Mar 2010 15:13

Sorry Dimon, I mean the windows file timestamp;

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 01 Apr 2010 14:04

This behaviour is connected with the specificity of work of MySQL server and it does not depend on MyDAC.

NoComprende
Posts: 135
Joined: Tue 09 Jan 2007 13:44

Re: How to update table timestamps without closing programme

Post by NoComprende » Thu 01 Apr 2010 15:06

NoComprende wrote:I'm aware this may be nothing to do with the MyDAC components but can anyone tell me how to get MySQL to update the window timestamps on any changed tables?

NoComprende
Posts: 135
Joined: Tue 09 Jan 2007 13:44

Post by NoComprende » Sun 04 Apr 2010 15:42

For anyone that's interested I think 'flush tables' solves the problem.

Post Reply