SqlTsUpdate%

Updates the value of a timestamp column in a specified table.

Syntax

SqlTsUpdate% ( sqlconn%, usqlconn%, tabnum%, tabname$ )

where

sqlconn%

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

usqlconn%

Is a SQL Server connection used only for updating the timestamp of the desired column. The value of usqlconn% is returned by SqlOpen%.

tabnum%

Is the number of the table to receive the new timestamp. Table numbers start at 1. The tabnum% parameter must refer to a browsable table. Use SqlTabBrowse% to determine whether the table can be browsed. If this value is 1, the tabname$ parameter is used to identify the table.

tabname$

Is a string containing the table name. The tabname$ parameter must refer to a browsable table. If the string is empty, tabnum% is used to identify the table. The value of tabname$ is returned by SqlTabSource$.

Returns

SUCCEED (1) or FAIL (0).

Remarks

SqlTsUpdate% is equivalent to calling SqlTsNewVal$ and SqlTsPut%. Like those functions, it is designed for use in browse mode. SqlTsUpdate% can update the timestamp column if either tabnum% or tabname$ is provided. If neither is provided, calling SqlTsUpdate% results in an error.

The usqlconn% connection must be clear ¾ that is, it cannot have any rows pending. After completing all the updates to the timestamp column, immediately close the usqlconn% connection.

See Also

SqlTabBrowse%, SqlTabSource$, SqlTsNewVal$, SqlTsPut%