SQL Anywhere database - latest update time without trigger ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

latest update time without trigger ?

P Merritt

2005-10-28, 8:23 pm

whenever a row is updated in my table I'd like to record the time. I'd
thought of using a trigger but
http://www.sybase.com/detail?id=1023801 says:
triggers to update columns with the latest update time and user information
can be replaced with the corresponding special values in the server" I've
been unable to figure out what those special values are (since all the rows
in my table had already been inserted before I realized I needed time as
well as date, the new time field is currently 0)

Sponsored Links