SqlTsNewVal$ and SqlTsNewVal&

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

Syntax

SqlTsNewVal$ ( sqlconn% )

where

sqlconn% ( )

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

Returns

The identifier of the updated row's new timestamp value. The identifier is an empty string if no timestamp is returned to the application because the update was unsuccessful or because the UPDATE statement did not contain a WHERE clause returned by SqlQual$.

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

Remarks

SqlTsNewVal$ is a DB-Library for Visual Basic browse-mode function. For a detailed discussion of browse mode, see DB-Library for Visual Basic Programming.

SqlTsNewVal$ provides information about the timestamp column. When used in an UPDATE statement, the WHERE clause returned by SqlQual$ 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). With SqlTsNewVal$, the application saves the new timestamp value, possibly for use with SqlTsPut%.

See Also

SqlColBrowse%, SqlColSource$, SqlQual$, SqlTabBrowse%, SqlTabCount%, SqlTabName$, SqlTabSource$, SqlTsNewLen%, SqlTsPut%