Navision Version Number in SQL

sgg

In SQL, The Table $ndo$dbproperty contains a Column Named databaseversionno This I believe is Unique for each Version of Navision Released.

1. How Can I get the Version Number in Native Navision Database apart from the Function in CodeUnit 1?

2. How Can I get this Number without Opening The Database? in Both the SQL Option and the Native Database Option?

ara3n

Well you can open the navision client, click on help and about.
All the clients on customer site will have the same version as the database, unless they've done a technical upgrade.

kine

If I understand, you need to have some MAGIC constants to identify version of NA by analyzing the DB file itself... it seems that it is on you, you will need to analyze first few bytes of the FDB file etc., but the result is not guaranteed :-)

Luc_VanDyck

Try contacting the author of this tool: Navision Starter v1.2