Where are the forms and code kept in SQL server version

brucem

Hi,

I'm im wrong here feel free to slap me across the face with a damp haddock....

In the traditional version of Navision any code changes, new forms, amendments etc were / are written to a central location so all users can get at them.

I guess this was in the DB itself...

Now if you are using a SQL database, where are those same forms / code units stored now ? Are they in the SQL database ?

If so where and what protection is there for them ?

Bruce

John_Tegelaar

Bruce, the objects and code are still in the SQL database, just like under C/Side. Any change will be available to all users at once.

The place where this information is stored, is hidden for the users, also when reading/writing the tables from outside Navision. Any special reason for worrying about protection?

John

brucem

HI John,

No real concerns about protection as such other than setting up allowing users to access SQL DB's via things such as ODBC or other effects such as creating new tables in the database without using navision to do so. Also i was interested in how / where the forms etc are hidden. In your more traditional Application you would create and distribute an application such as a VB front end that had links to the db. In this case it's slightly different.

Bruce

John_Tegelaar

Tables created outside Navision will not show in the list of tables in Navision. There are more things involved when Navision creates a table, amongst others updating the internal references.

Through ODBC you can retrieve and insert records into the tables, but that's only the data part.

John

Dennis_Decoene

In my opinion, everything "compiled" is stored in the *.ldf file, in the same location as the *.mdf file. It cannot be accessed with anything else but navision.

How? Dunno...