Re: timestamp column

Posted in 1998

Nils Myklebust — Thu, 13 Aug 1998 11:08:35 GMT — source: Informix-list mailing list archive (1991-1998)

On Wed, 12 Aug 1998 08:06:00 +0800, Syed <sas@mastic.gov.my> wrote: > >How do I check if my table have any time-stamp columns? There is no built in timestamp column type in any Informix database engine unfortunately. That is if you refer to a column that can tell you whether a row is updated after you last read it. I seem to remember that PowerBuilder have support for optimistic locking via rereading the row and comparing all columns to see if any where changed. If that isn't built in it is easy enough to do yourself. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)