Before you get carried away I don’t mean you can do any coding in uniface. In fact, you can ask about the $hits and it may suggest you have a dodgy stomach. 🤣
What I did which is something I have found needed in many companies but with no easy solution.
How do I get an ERM for my project. The problem is it either takes too long and is unusable, or it simply can not be done as we hold relationships in uniface and not in the database.
So, I tasked it to AI.
I gave AI the DICT data for fields, tables (± 1000 of tables), subtypes, relations, keys… so 5 files of data.
I thien started chatting with AI.
The result is a stand alone .html file. You can zoom, wildcard the tables, see the relationships, correct any overlaps. For more features I would suggest chatting a bit more.
The source code is easily readable but seems to consist of lots of drawing lines. You probably would not want to modify the code manually.
So, the easy bit is to give it the data, then you need to chat until it gives you the desired result.
Start with, “take my data and create a standalone ERM’
You end up with a snapshot of your database model at the time you took your DICT data. If you want it to be up to date you will need to chat some more with it, or simply start again.
If you want to give it a go, let me know if you can’t get started, but realistically the hard part is the chatting bit.
