Table_EndShrink()

The Table_EndShrink() function closes the shrink table and finishes the table shrink.

Syntax

Table_EndShrink(product_ID, table table_name)

Parameters

• product_ID – An integer specifying the product ID of the dictionary containing the table being shrunk.

• table table_name – The name of the original table being shrunk.

Return value

An integer containing the result of the function. The result is 0 if the shrink table was successfully closed.

Comments

This function is used to complete the table shrinking process. Shrinking is the process of removing unused space from a data table. The Table_CopyShrinkRecords() function copies the contents of the original table to the temporary table created with Table_StartShrink(). This transfer allows the temporary table to store only records from the original table; excess space in the original table isn’t transferred to the temporary table.

After the copy is complete, the Table_EndShrink() function completes the table shrink. Depending upon the location of the temporary table, Table_EndShrink() will do one of the following:

• If the temporary table created by Table_StartShrink() is created in the same directory as the original table, the original table is removed and the temporary is renamed. Thus, the temporary table becomes the new table.
• If the temporary table is created in a different directory, the original table is deleted and re-created, and this command copies all the records from the temporary table to the new original table. The temporary table is then deleted.

Documentation Feedback

---