Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to retrieve info on latest write to a table?
Message
From
06/10/2002 08:37:57
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00707680
Message ID:
00708184
Views:
18
I'm not sure I understand -

In my VFP screen I'd like to inform the user that the data from the SQL server table that (s)he's looking at was last updated at 2002.10.10 22:00

There is no row in the table that could provide this info, and I have no influence on the DB design, so I'm not likely to get one.

>Either create a trigger to update a column on the row or have your stored procedure do it.
>
>-Mike
>
>>There's bound to be a way to determine the date / time of the latest update to a table, and I did search, but so far with no luck.
>>
>>So, help is truly appreciated.
>>
>>TIA
>>
>>Peter
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform