SqlTextUpdate1Row%

Updates one row of results in a text column. All subsequent rows, if any, are removed from the results buffer.

Syntax

SqlTextUpdate1Row% ( sqlconn%, objname$, column%, text$ )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% 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$

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

Returns

SUCCEED (1) or FAIL (0).

Remarks

SqlTextUpdate1Row% is a utility function that performs several actions to reduce the number of steps for updating the data in a text or image column of a single row. SqlUpdate1Row% is equivalent to calling SqlTxPtr$, SqlTxTsPut%, and SqlWriteText%. The data is updated in the current row determined by a call to SqlNextRow%. You can call SqlTextUpdate1Row% any time after you call SqlNextRow%.

See Also

SqlTxPtr$, SqlTxTsPut%, SqlWriteText%, SqlTextUpdateManyRows&