Navision Table/Field Value populated by SQl queries or external procedures

elflacodemiami
elflacodemiami Member Posts: 10
in NAV Three Tier
Hi.
I am NOT NEW to Navision however for the company I am working now have a "practice" to update data in general via SQL.
Can somebody send link to a good article why this is not a good practice in our Navision world. It looks like I am the one from the OLD fashion method or what?
Carlos Garcia

Best Answer

  • elflacodemiami
    elflacodemiami Member Posts: 10
    Answer ✓
    Thank you for your reply, we are running a Classic SQL client not RTC
    Carlos Garcia

Answers

  • kaspermoerch
    kaspermoerch Member Posts: 43
    Take a look at the answers to this question here on Mibuso: Inserting data in Navision Tables through SQL Server Query.

    One problem that I've experienced with this approach is that sometimes the data cache on the Service Tier is not updated, because the database modifications are not triggered through the Service Tier. The user might then experience missing data, until they do a modification (insert/modify/delete) on the table, which brings the data cache on the Service Tier up to speed.
  • kriki
    kriki Member, Moderator Posts: 9,127
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]


    It also help putting the statement "SELECTLATESTVERSION" in NAV.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • elflacodemiami
    elflacodemiami Member Posts: 10
    Answer ✓
    Thank you for your reply, we are running a Classic SQL client not RTC
    Carlos Garcia

Categories