Updates the target database with corrections that have been made in the pipeline user object’s Error DataWindow.
Pipeline objects
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 |
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.
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.
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)