Tech Tip: Do not modify 4D system tables programmatically
PRODUCT: 4D | VERSION: 11.6 | PLATFORM: Mac & Win
Published On: April 2, 2010
Developers can use system tables to get information regarding database structures. They cannot write or change information in the system tables. For example the following code will generate a runtime error:
Begin SQL UPDATE _USER_TABLES SET TABLE_NAME = 'Company' WHERE TABLE_ID = 2 End SQL |
Of course, if you edit the structure via the 4D Structure Editor or by adding tables in SQL then the system tables update accordingly.