Searching for the Data Dictonary inside Navision SQL db

alfastar

Hi
I am working on a project where I have in a way to reproduce the Navision SQL database structure in another application. But this has to be done in such a way that when a table is changed in Navision or a table is added, this other application must be able to detect these changes and reflect them. On another hand, once the Navision SQL database structure is reproduced, this application accesses directly the Navision SQL database through ODBC and extracts the information from it. In order for the application to be able to detect the changes in the database and reflect them I need to find the information about all the properties and relations of the fields inside the Navision SQL database. There is a virtual table: 2 000 000 041 'Field' where one can find the properties of all the fields from all the tables and the relations. This table exists only when the Navision application is running and it is somewhere in the application. That means that this table is not physically stored inside the Navision SQL database, so when the application access the Navision SQL db through ODBC connection it cannot find this table inside the db. Still, I have this information inside this table and by exporting it or dealing in some other ways I can have the properties and relations of the fields.

However, there is a problem. In table 'Field' there is no information about the conditional relations. I am talking about the fields in Navision that can relate to different tables depending on the value of another field. For example, 'Bal. Account No' field in Table 17 G/L Entry relates to Customer table if the value of 'Bal. Account Type' is 'Customer' and if it is 'Vendor', 'Bal. Account No' relates to Vendor table. So in Navision the relations of the 'Bal. Account No' look as conditional statements. It is the information about these conditional relations that I am still looking for. I cannot find where the information about this conditional relations is stored within the Navision SQL database, so that I could access it through ODBC. So, if anybody knows where I can find it , please help me!

kriki

I am afraid you will never find this information. Not even in Navision exists a table where to find it. This information is stored in the table-object.

CtrlShiftF11

You need to talk to the guys who developed the merge tool.

Marije_Brummel

Yes, it is stored somewhere in Navision very deep.

I read some post once from someone explaining how to get the binairy object from the BLOB reference. :?

But I think it is realy a comlex thing so I will take a lot of time.

alfastar

Thanks to all!!!
I will try to talk to the guys that designed the developers toolkit - when I import the objects as a txt file in the toolkit, I guess it parses the txt file and puts all the properties and relations in the Developers toolkit's tables 'Property' and 'Relation to Table'. So it could help me.
I will also check what I can do with the 'BLOB Reference' field in the Object table. So if I make any progress or have further questions - I will ask again.

Vamci

How to check if importin text file has been completed?
Since I am importing a text file, Navision does not given any message or write information in any table or log file that import process is complete and its result.

Can you help me if you have such information?

Thanks
Vamci