Return the new value of a text timestamp after a call to dbwritetext.
DBBINARY *dbtxtsnewval(dbproc) DBPROCESS *dbproc;
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.
A pointer to the new text timestamp value for the SYBTEXT or SYBIMAGE value modified by a dbwritetext operation. This pointer may be NULL.
Every database column of type SYBTEXT or SYBIMAGE has an associated text timestamp, which is updated whenever the column’s value is changed. 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 and may be examined by calling dbtxtimestamp.
After each successful dbwritetext operation (which may include a number of calls to dbmoretext), the server will send the updated text timestamp value back to DB-Library. dbtxtsnewval provides a way for the application to get this new timestamp value.
The application can use dbtxtsnewval in two ways. First, the return from dbtxtsnewval can be used as the timestamp parameter of a dbwritetext call. Second, dbtxtsnewval and dbtxtsput can be used together to put the new timestamp value into the DBPROCESS row buffer, for future access using dbtxtimestamp. This is particularly useful when the application is buffering result rows and does not need the new timestamp immediately.