SqlTextUpdateManyRows&

Updates all rows of results in a text or image column, starting from the current row.

Syntax

SqlTextUpdateManyRows& ( sqlconn%, usqlconn%, objname$, column%, text$ )

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 desired column. The value of usqlconn% is returned by SqlOpen%.

objname$

Is the database table and column name. The table name and the column name are separated by a period.

column%

Is the number of the column. The first column in a table is number 1.

text$

Is a string containing the text or image replacing the current data on the server.

Returns

The number of updated rows. If an error occurs, -1 is returned.

Remarks

SqlTextUpdateManyRows& replaces the text or image of all rows in a column, starting from the current row. It is usually used to change the text or image of an entire column, starting from the first row.

SqlTextUpdateManyRows& performs several actions that reduce the number of steps for updating the data in a text or an image column of a single row. This function is equivalent to calling SqlTxPtr$, SqlTxTsPut%, and SqlWriteText%. The data is updated in the current row, which is determined by a call to SqlNextRow%.

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

Call SqlTextUpdateManyRows& any time after you call SqlResults%. Updates begin on the next row from the current pending row or, if SqlNextRow% has not been called, updates begin on the first row.

See Also

SqlTxPtr$, SqlTxTsPut%, SqlTextUpdate1Row%, SqlWriteText%