Re: Help required with Timestamp field

pankaj_wolfhunter@xxxxxxxxxxx wrote: 
Thank for the reply.
I didnt get it, if its just a sequence of numbers and that too in hex
form,
why do we have it. i mean if we cant export this, doesnt that mean that

that we are loosing out that information, which is as good as not
having only.

TIA


ASE is using the timestamp internally to track changes to datapages for recovery purposis.
You can basically use it if you want to implement optimistic locking and such things.
As an example, if you have a web page where people can chenge data.
You retrieve the record and it's timestamp, and release the lock on that page.
Then the user changes the info.
On writeback of the data you check if the timestamp has changed or not.
If it has changed then the record was changed in the meantime, if it hasn't chenged it's save to writeback the new info.

joop

--
Senior Consultant Sybase Professional Services

She asked me, "What's your sign?"
I blinked and answered "Neon,"
I thought I'd blow her mind...
.