>The timestamp type is capable of storing up to ten-thousandths of a
>second. However, CURRENT_TIMESTAMP, CURRENT_TIME and the date literal
>'NOW' do not store anything finer than seconds. If your server is on
>Windows, you can use the UDF from FBUDF.dll, GetExactTimeStamp, to get a
>timestamp with ten-thousandths of a second.

Thanks for the information.

>Firebird already does optimistic locking...what did you have in mind?

I want to use a timestamp (or version) to know if
someone has already modified a record since my last read. This one is
to avoid long read transactions. I am aware that Firebird
can handle long read quite gracefully but I do not think this is
generally a good idea.

--
Best regards,
Alexander mailto:saho@...