Integer. Returns 1 if it succeeds and a negative number if an error occurs.
Error values are:
-1 pipe open failed
-2 too partition Columns
-3 table already exists
-4 table does not exist
-5 missing connection
-6 wrong arguments
-7 column Mismatch
-8 fatal SQL error in Source
-9 fatal SQL error in destination
-10 maximum number of errors exceeded
-12 bad table syntax
-13 key required but not supplied
-15 pipe already in progress
-16 error in source database
-17 error in destination Database
-18 Destination database is read-only
If any argument's value is NULL, Start returns NULL.
String ls_errortext
IF IsNull (ai_ErrCode) THEN
Ls_errortext = "null parameter passed! "
RETURN''
END IF
Choose case ai_ErrCode
CASE-1
Ls_errortext = "An error occurred while opening the data pipeline! Check whether all objects are valid. Error Code: "+ String (ai_ErrCode)
CASE-2
Ls_errortext = "the number of columns exceeds the upper limit! Error Code: "+ String (ai_ErrCode)
CASE-3
Ls_errortext = "the target table already exists! Error Code: "+ String (ai_ErrCode)
CASE-4
Ls_errortext = "the target table does not exist! Error Code: "+ String (ai_ErrCode)
CASE-5 // common start () function and repair () function common error code
Ls_errortext = "the connection is disconnected! Error Code: "+ String (ai_ErrCode)
CASE-6
Ls_errortext = "error parameter! "
CASE-7
Ls_errortext = "the column type does not match! Error Code: "+ String (ai_ErrCode)
CASE-8
Ls_errortext = "source SQL syntax error! Error Code: "+ String (ai_ErrCode)
CASE-9 // common
Ls_errortext = "the target SQL syntax is incorrect! Error Code: "+ String (ai_errcode)
Case-10 // common
Ls_errortext = "the number of errors exceeds the maximum number of errors defined! Error Code: "+ String (ai_errcode)
Case-11 // repair error code
Ls_errortext = "Invalid Window handle! Error Code: "+ String (ai_errcode)
Case-12 // common
Ls_errortext = "Incorrect table syntax! Error Code: "+ String (ai_errcode)
Case-13
Ls_errortext = "null primary key value! Error Code: "+ String (ai_errcode)
Case-15 // common
Ls_errortext = "this data pipeline has been opened! Error Code: "+ String (ai_errcode)
Case-16
Ls_errortext = "the error occurs in the source database! Error Code: "+ String (ai_errcode)
Case-17 // common
Ls_errortext = "the error occurs in the target database! Error Code: "+ String (ai_errcode)
Case-18 // common
Ls_errortext = "target database read-only! Error Code: "+ String (ai_errcode)
End choose
Return ls_errortext