The Table_Compare() function compares the structure of an existing table on the current data source to that table’s definition in the application dictionary.
Table_Compare(table table_name)
• table table_name – The name of the table to be validated.
An integer corresponding to one of the following constants:
![[spacer]](1p.gif){kind=small}
|
Constant |
Description |
|---|---|
|
STATUS_SUCCESS |
The table structure and table definition match. |
|
STATUS_ERROR |
Discrepancies were found between the table structure and the table definition, or some other error occurred. |
If you create your own tables outside of Dexterity, or are creating a Dexterity application to access data in an existing SQL table, use the Table_Compare() function to verify that the application dictionary’s table definition matches the actual table in the data source.