4D v16.3
GET MISSING TABLE NAMES
- 4D Language Reference
-
- Structure Access
-
- Structure Access Commands
- CREATE INDEX
- DELETE INDEX
- EXPORT STRUCTURE
- Field
- Field name
- Get external data path
- GET FIELD ENTRY PROPERTIES
- GET FIELD PROPERTIES
- Get last field number
- Get last table number
- GET MISSING TABLE NAMES
- GET RELATION PROPERTIES
- GET TABLE PROPERTIES
- IMPORT STRUCTURE
- Is field number valid
- Is table number valid
- PAUSE INDEXES
- REGENERATE MISSING TABLE
- RELOAD EXTERNAL DATA
- RESUME INDEXES
- SET EXTERNAL DATA PATH
- SET INDEX
- Table
- Table name
GET MISSING TABLE NAMES
| GET MISSING TABLE NAMES ( missingTables ) | ||||||||
| Parameter | Type | Description | ||||||
| missingTables | Text array |
|
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 SQL 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).
Product: 4D
Theme: Structure Access
Number:
1125
Created: 4D v12
missing tables
4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)
