Tdbf question
lazarus / 16-Databases

----------------------------------------------------------------------
SteveSS · 2017-06-30 09:48

Hi Chaps.  I have written a Lazarus program to record match results
for a local team that I belong to.  I entered some results this
morning, and when I backed up the data I noticed that the .mdx file
for the results database did not copy - its last update date on
Explorer shows 27/06/2017.  When I check the results, they are all
there, with the correct date, and in the correct sequence.  I am
intrigued as to why the .mdx file does not show as updated today.  Any
thoughts?

----------------------------------------------------------------------
ahiggins · 2017-06-30 09:51

How are you backing up the table?

----------------------------------------------------------------------
SteveSS · 2017-06-30 10:07

Just using xcopy in a .bat file - not part of the program.

----------------------------------------------------------------------
ahiggins · 2017-06-30 10:38

Not sure, I've just tested on windows 7 64bit xcopy tablename.*
d:\backup_path\ /v  with no issue. maybe try recreating the index.

----------------------------------------------------------------------
SteveSS · 2017-06-30 11:32

Sorry All - I am being a bit dim (not for the first time).  The
results table is  keyed on a date indicator (T/S/U for Thursday /
Saturday / Sunday) plus the player name.  This means that the index
will only change if there is a new player, or an existing player plays
on a date they have not played on before.  All of the results I
entered today were for existing players, who had played on a Thursday
before.  So no index change.  The last update for the results index on
the 27/06/2017 was because I entered a result for a new player.
Arghhhh!!!

SOLVED

----------------------------------------------------------------------
ahiggins · 2017-06-30 12:24

Result, it was always going to be something simple  .  I take it your
batch file was using a /D or /A (/M) switch?

----------------------------------------------------------------------
SteveSS · 2017-06-30 13:48

Yes - batch command is : xcopy C:\LData   F:\LData /F /D /E /I /Y

Thanks for joining in on this.