Where are the forms and code kept in SQL server version

brucem
brucem Member Posts: 86
edited 2001-01-30 in Navision Financials
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

Comments

  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    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
    brucem Member Posts: 86
    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
    John_Tegelaar Member Posts: 159
    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
    Dennis_Decoene Member Posts: 123
    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...

Categories