4D v13.4

GET MISSING TABLE NAMES

Home

 
4D v13.4
GET MISSING TABLE NAMES

GET MISSING TABLE NAMES 


 

GET MISSING TABLE NAMES ( missingTables ) 
Parameter Type   Description
missingTables  Text array in Names of missing tables in the database

The GET MISSING TABLE NAMES command returns the names of all the missing tables of the current database in the missingTables array.

Missing tables are tables whose data are present in the data file but that do not exist at the level of the current structure. This can happen when a data file is opened with different versions of the structure.

Typically, the scenario is as follows:

  • The developer provides a structure containing tables A, B and C,
  • The user adds the custom tables D and E, using, for example, the integrated commands of 4D, and stores data in these tables,
  • The developer provides a new version of the structure. It does not contain tables D and E.
    In this case, the user version of the database still contains data from tables D and E, but it cannot be accessed. The GET MISSING TABLE NAMES command will return the names "D" and "E". 

Once you have identified the missing tables of the database, you can reactivate them via the REGENERATE MISSING TABLE command.

Note: The data of missing tables are erased when the data file is compacted (if the tables have not been regenerated).

 
PROPERTIES 

Product: 4D
Theme: Structure Access
Number: 1125

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D v12

 
SEE ALSO 

REGENERATE MISSING TABLE

 
TAGS 

missing tables***