dbtxtimestamp

DB Library for C

DB Library for C

dbtxtimestamp

Returns the value of the text timestamp for a column in the current row.

Syntax

LPCDBBINARY dbtxtimestamp (
PDBPROCESS
dbproc,
INT
column );

Arguments

dbproc

Is the DBPROCESS structure that is the handle for a particular workstation or Microsoft® SQL Server™ 2000 process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

column

Is the number of the column. The first column in a table is number 1. For further information, see dbadata.

Returns

A DBBINARY pointer to the text timestamp for the column. This pointer can be NULL when the text or image value is null, or when there is no current row.

Caution  Do not modify this identifier in any way. Modifying the identifier can cause unpredictable results.

Remarks

Every database column of type SQLTEXT or SQLIMAGE has an associated text timestamp, which marks the time of the column's last modification. Use the text timestamp with dbwritetext to ensure that one user doesn't inadvertently overwrite another's modifications to the same value in the database. The text timestamp is returned to the DBPROCESS when a Transact-SQL SELECT statement is performed on a SQLTEXT or SQLIMAGE column.

The length of a non-NULL text timestamp is always DBTXTSLEN (currently defined as eight bytes). Call dbtxtimestamp only after dbnextrow or dbgetrow has returned REG_ROW.

See Also

dbreadtext

dbwritetext