Put the new value of a text timestamp into the specified column of the current row in the DBPROCESS.
RETCODE dbtxtsput(dbproc, newtxts, colnum) DBPROCESS *dbproc; DBBINARY *newtxts; int colnum;
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. It is returned by dbtxtsnewval.
The number of the select list column of interest. Column numbers start at 1.
SUCCEED or FAIL.
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 allows the application to get this new timestamp value. The application can then use dbtxtsput 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.
