rs_update

Updates a single row in a table in a replicate database.

Examples

Example 1

Replaces the existing rs_update function
string for the <authors> table with one that
is similar to the default function string generated by Replication
Server for the system-provided function-string classes.

Replication Server
executes rs_update to update a single
row in a table. The row is identified by the primary key columns
defined in a replication definition for the table.

The rs_update function
has replication definition scope.

Replication Server generates an rs_update function
string for the system-provided function-string classes when you
create the replication definition.

If you use a user-created base function-string class,
create an rs_update function string
for each replication definition.

Create or customize an rs_update function
string at the Replication Server where you created the replication
definition.

The default generated function string for rs_update,
for the <rs_sqlserver_function_class> and <rs_default_function_class> classes
for each replication definition, uses the Transact-SQL update command
syntax. It replaces all columns in the row, and identifies the row
with a where clause that specifies the pre-update
values, or before image, of the primary key columns.

When set autocorrection is on,
Replication Server does not use rs_update. Instead,
it calls rs_delete to remove the existing
row and rs_insert to insert the row.

Replication Server cannot send <text>, <unitext>,
or <image> data with rs_update, but
it can report the status of <text>, <unitext>,
or <image> data with the <text_status> modifier.
For a description of the <text_status> modifier,
see rs_datarow_for_writetext.
Data of type <text>, <unitext>,
or <image> is sent to the replicate database
with the rs_get_textptr, rs_textptr_init, rs_datarow_for_writetext,
and rs_writetext functions.