SqlTxTimeStamp$

Returns the identifier for the text timestamp for a column in the current row.

Syntax

SqlTxTimeStamp$ ( sqlconn%, column% )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

column%

Is the number of the column. The first column in a table is number 1.

Returns

The identifier of the text timestamp for the column. This identifier can be an empty string.

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

Remarks

Every text or image column has an associated text timestamp that marks the time of the column's last modification. The text timestamp is useful in conjunction with SqlWriteText% to ensure that two competing users do not inadvertently wipe out each other's modifications in the database. The text timestamp is returned to the sqlconn% when a Transact-SQL SELECT statement is performed on a SQLTEXT or SQLIMAGE column.

The length of a non-NULL text timestamp is always SQLTXTSLEN (currently defined as eight bytes). Call SqlTxTimeStamp$ only after SqlNextRow% or SqlGetRow% has returned regrow.

Example

See the Windows-based programming example for SqlWriteText%, later in this chapter, which uses SqlTxTimeStamp$.

See Also

SqlTxPtr$ and SqlWriteText%