mibuso.com
Home› NAV/Navision Classic Client
Options

how to edit through navision a file created in sql server ?

mistralmistral Member Posts: 13
edited 2005-05-10 in NAV/Navision Classic Client
hi all ...

how can i edit through navisio 3.7 a file created in sql server ???

Comments

  • Options
    HalMdyHalMdy Member Posts: 429
    Sorry but ...

    What do you mean by "file created in SQL server" ?
  • Options
    WaldoWaldo Member Posts: 3,412
    and with "Edit through Navision..." ?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    mistralmistral Member Posts: 13
    I have create a file manually in sql server.
    I want to have access and to see and edit data via a form in navision
  • Options
    jm1jm1 Member Posts: 13
    mistral wrote:
    I have create a file manually in sql server.
    I want to have access and to see and edit data via a form in navision

    Just for curiousity, how did you create the file manually in sql server?
  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    I guess you created a table in a SQL database without using the finsql.exe client. You can use this table in Navision, if you create a view to this table ... but don't ask me how. :roll:
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    WaldoWaldo Member Posts: 3,412
    Well, It's pretty easy:

    1) In SQL Server Enterprise Manager: Create you view and name it like a navision table is named: e.g. Companyname$Tablename
    2) In Navision:
    a. Create a table with the same fields as the view ...
    b. Set the property "LinkedObject" to "Yes"

    Done!

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    fbfb Member Posts: 246
    Read all about it here:

    Section 7.4 - "Linked Objects" in the Application Designers Guide (w1w1adg.pdf on the Product CD).
  • Options
    davmac1davmac1 Member Posts: 1,283
    I have done this with Views to get around Navision's sorting problem (can only sort on fields actually in Navision table).
    It works well and the performance is excellent.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    mistralmistral Member Posts: 13
    thanks all , it works ...
  • Options
    ShenpenShenpen Member Posts: 386
    But you have to buy those table is licence?

    I think the whole point of using SQL is to save on licence, no? I mean tables are EXPENSIVE.

    IMHO :)
    Do It Yourself is they key. Standard code might work - your code surely works.
  • Options
    ShenpenShenpen Member Posts: 386
    Actually to save on licence, I would use Access and link SQL tables into it. Acces provides a very Navision-like, and even web-enable UI very easily.
    Do It Yourself is they key. Standard code might work - your code surely works.
Sign In or Register to comment.