Repair

Description

Updates the target database with corrections that have been made in the pipeline user object’s Error DataWindow.

Applies to

Pipeline objects

Syntax

pipelineobject.Repair ( destinationtrans )

Argument

Description

pipelineobject

The name of a pipeline user object that contains the pipeline object being executed

destinationtrans

The name of a transaction object with which to connect to the target database

Returns

Integer. Returns 1 if it succeeds and a negative number if an error occurs. Error values are:

If any argument’s value is null, Repair returns null.

Usage

When errors have occurred during a pipeline data transfer, Start populates its pipeline-error DataWindow control with the rows that caused the errors. The user or a script can then make corrections to the data. The Repair function is usually associated with a CommandButton that the user can click after correcting data in the pipeline-error DataWindow.

If errors occur again, the rows that are in error remain in the pipeline-error DataWindow. The user can correct the data again and click the button that calls Repair.

Examples

Example 1

This statement connects to the destination database using the transaction instance variable i_dst. It then updates the database with the corrections made in the Error DataWindow for pipeline i_pipe:

i_pipe.Repair(i_dst)

See also