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

elflacodemiami

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?

elflacodemiami

Thank you for your reply, we are running a Classic SQL client not RTC

kaspermoerch

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

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]


It also help putting the statement "SELECTLATESTVERSION" in NAV.

elflacodemiami

Thank you for your reply, we are running a Classic SQL client not RTC