Return the value of the text timestamp for a column in the current row.
DBBINARY *dbtxtimestamp(dbproc, column) DBPROCESS *dbproc; int column;
A pointer to the DBPROCESS structure that provides the connection for a particular front-end/server process. It contains all the information that DB-Library uses to manage communications and data between the front end and server.
The number of the select list column of interest. Column numbers start at 1.
A DBBINARY pointer to the text timestamp for the column of interest. This pointer may be NULL.
Every database column of type SYBTEXT or SYBIMAGE has an associated text timestamp, which marks the time of the column’s last modification. The text timestamp is useful in conjunction with the dbwritetext function, to ensure that two competing application users do not inadvertently wipe out each other’s modifications to the same value in the database. It is returned to the DBPROCESS when a Transact-SQL select is performed on a SYBTEXT or SYBIMAGE column.
The length of a non-NULL text timestamp is always DBTXTSLEN (currently defined as 8 bytes).
An application must select a row containing a text or image value before calling dbtxtimestamp to return the associated text timestamp. The select causes a copy of the text timestamp to be placed in the application’s DBPROCESS. The application can then retrieve this text timestamp from the DBPROCESS using dbtxtimestamp.
If no select is performed prior to the call to dbtxtimestamp, the call will result in a DB-Library error message.
For an example that uses dbtxtimestamp, see the dbwritetext reference page.
