Repair
PowerScript function
Description
Updates the target database with corrections that have been made in
the pipeline user object’s Error DataWindow.
Applies to
Pipeline objects
Syntax
|
1 |
pipelineobject.Repair ( destinationtrans ) |
|
Argument |
Description |
|---|---|
|
pipelineobject |
The name of a pipeline user object that contains the |
|
destinationtrans |
The name of a transaction object with which to connect to |
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:
|
1 |
i_pipe.Repair(i_dst) |
See also