You’re offline. This is a read only version of the page.
75
Hello,
I have list of many table IDs in AX12 and I need to get their table aot names... For "normal" tables it is OK, I can get it using SQL from SQLDICTIONARY table, but if the table "B" is inherited from some other table "A", there are fields from table "B" under table "A". But under table "A" are only fields, the problem is I would also need to know, where are stored the table names, table IDs of inherited tables. As I have been told, it should be stored somewhere, but I have no idea where.
Thanks
This information doesn't exist in the normal AX database. You would be much better off if you used the right way - the AX application. If you bypass the whole application and connect to the storage directly, you can get into a lot of troubles, as I mentioned in your previous thread.
The key problem is that there is nothing like table "B" in the database. "B" is an application-layer object, while you're looking into the database layer. You should decide whether you want to work with database-layer objects, or application-layer objects, and then the best approach is doing it at the right layer.
Didn't you consider using something like the metadata service to get information about application objects, and then use this information for your DB queries?
Anyway, there should be a way if you insist of using a database, but you'll need to look to a different one: the modelstore database.
Share
Report
All responses (
Answers (
