SQL Anywhere database

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

Re: got it

P Merritt

2005-10-28, 8:23 pm

finally found reference to "special" value under timestamp in the index
..thanks anyway

"P Merritt" < pmerritt@transcendon
line.com> wrote in message
news:436280b1$2@foru
ms-2-dub...
> 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