Updates all rows of results in a text or image column, starting from the current row.
SqlTextUpdateManyRows& ( sqlconn%, usqlconn%, objname$, column%, text$ )
where
The number of updated rows. If an error occurs, -1 is returned.
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.
SqlTxPtr$, SqlTxTsPut%, SqlTextUpdate1Row%, SqlWriteText%