And if I remember correctly, Bill, you had a nice solution to that particular problem!
In my case, it doesn't _really_ matter if the date gets changed on a RESTORE - reload is okay. I'm sure I could look it up - you used IFNULL or IFEQ around the date to force the stored date to be restored? Regards, Alastair. ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 15, 2004 8:44 PM Subject: [RBG7-L] - Re: Problem with column DEFAULT > On 15 Jul 2004 at 20:39, Alastair Burr wrote: > > > Instead of using the default I use the compute and expression options: > > I use .#DATE quite happily to get the insert date - surely others do > > this? > > Alastair, > > I believe there is another problem with this approach: when you reload the database, > all column values will be changed to the date of the reload. > > Bill >
