The Table_EndConversion() function finishes a table conversion. If the table was converted successfully, this function deletes the source table and renames the destination temporary table to take the place of the source table. If the table was not converted successfully, the source table is kept and the destination temporary table is deleted.
|
The Table_End_Conversion() function can be used only for c-tree and Pervasive.SQL tables. It can’t be used for SQL tables. |
Table_EndConversion(table source_table, table destination_table, l_converted)
• table source_table – The technical name of the source table. (Note that unlike Table_StartConversion(), this isn’t a string parameter.)
• table destination_table – The technical name of the destination table. (Note that unlike Table_StartConversion(), this isn’t a string parameter.)
• l_converted – A boolean indicating whether the table conversion was successful. If true is passed to this parameter, the source table will be deleted and the destination temporary table will be renamed to take the place of the source table. If false is passed to this parameter, the source table will be kept and the destination temporary table will be deleted.
An integer value indicating whether any table errors occurred while the source and destination tables were being renamed or deleted. The values returned correspond to those returned by the err() function.
During the table conversion process, you must monitor whether any unexpected table errors occurred. If any unexpected errors occur, false should be passed to the l_converted parameter so the original table won’t be deleted.