Hi Dan
You could add another field to the table (perhaps called somethnig like DT_CREATED) that's not changed by the desktop. Just set its default value to getdate() on the SQL server and each time you insert a record that field will be populated with the server datetime.
Cheers,
Andrew
>I'd like to store the server time that a record is recorded just in case the time on the desktop is wrong. Is there a way to use the server time?
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.