Access information in other SQL Database

Afonso
Afonso Member Posts: 27
edited 2009-10-09 in NAV/Navision Classic Client
Hello all,

The idea is inside the application(Dynamics Nav), call a procedure to open one SQL database (not NAV), read a table and import it to a Nav table inside our company.
If anybody has done something like that, please send me ideas, advises, tips, etc


Best regards,
Afonso

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    You could search the forum for ADO.
  • bbrown
    bbrown Member Posts: 3,268
    Or use SQL Views and linked tables. If NAV is also SQL.
    There are no bugs - only undocumented features.
  • Afonso
    Afonso Member Posts: 27
    Hi Brown,

    How do we connect a Nav table to a view?


    Regards,
    JA
  • bbrown
    bbrown Member Posts: 3,268
    Afonso wrote:
    Hi Brown,

    How do we connect a Nav table to a view?


    Regards,
    JA


    See the "Application Designers Guide" for details. But basically, Create a view, create a NAV table with same field names, save as same name as table, and set the 'Linked Table' property.
    There are no bugs - only undocumented features.

Categories