The Update procedure
This update adds the Master/Details object type used by Active Table Editor. Run it when the application supports Master/Details screens but the repository has not been updated with the matching object type. Parent rows, child rows, and one repository row to keep them on speaking terms.
This page is for Active Table Editor. Other repository update guides in this section cover Advanced ETL Processor and Visual Importer ETL repositories.
The SQL inserts the Master/Details object type and assigns it to the object type group used by Active Table Editor.
Before you run the SQL
- Create a repository backup.
- Stop Active Table Editor and any services using the repository.
- Confirm that you are updating the active repository database.
- Restart Active Table Editor after applying the update.
Run this SQL against the repository
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('1005','Master/Details')
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=160000
WHERE OBJECT_TYPE= '1005' /* Master Details*/After the repository update
Restart Active Table Editor and check that Master/Details screens are available. If the option is missing, check the repository connection first. The wrong database is very good at accepting SQL and then contributing absolutely nothing useful.