How to update table timestamps without closing programme
Posted: 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?
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?