dbtsnewlen

Returns the length of the new value of the timestamp column after a browse-mode update.

Syntax

INT dbtsnewlen ( PDBPROCESS dbproc );

where

dbproc

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

Returns

The length, in bytes, of the new timestamp value for the updated row. If no timestamp was returned to the application (because the update was unsuccessful or because the UPDATE statement did not contain the TSEQUAL built-in function), the function returns -1.

Remarks

The dbtsnewlen function is one of the DB-Library browse-mode functions. For a detailed discussion of browse mode, see Browse Mode in Programming with DB-Library.

The dbtsnewlen function provides information about the timestamp column. The WHERE clause returned by dbqual contains a call to the TSEQUAL built-in function. When such a WHERE clause is used in an UPDATE statement, the TSEQUAL function places a new value in the updated row's timestamp column and returns the new timestamp value to the application (if the update is successful). The dbtsnewlen function allows the application to save the length of the new timestamp value, possibly for use with dbtsput.

See Also

dbcolbrowse, dbcolsource, dbqual, dbtabbrowse, dbtabcount, dbtabname, dbtabsource, dbtsnewval, dbtsput; Bulk-Copy Functions