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 |
Return value
Integer. Returns 1 if it succeeds and a negative number if an error occurs. Error values are:
-5 -- Missing connection
-9 -- Fatal SQL error in destination
-10 -- Maximum number of errors exceeded
-11 -- Invalid window handle
-12 -- Bad table syntax
-15 -- Pipe already in progress
-17 -- Error in destination database
-18 -- Destination database is read-only
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
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
