Auto Update Data after SQL Syntax - Currpage.update is not working

julkifli33

Hi All,
I have 1 customization using System.Data.SqlClient.SqlConnection
insert and update data is successfull
but the problem is sometimes when i open the page it will not changed immediately.
after i press refresh then it will change.
i have added in OnOpenPage ()
Currpage.update;

but still not working.
any idea what should I add?

lynge

This is fundamentally the wrong way of inserting/updating data in NAV/BC - you should use webservices instead.
When that said, you can probably use this command: https://docs.microsoft.com/en-us/dynamics-nav/selectlatestversion-function--database-
...to fix it, but it will still be the wrong approach as it will hurt performance...

SanderDk

@julkifli33,
Depending on you NAV version, you can actually use webservice between different NAV databases.

I will allways agree with @lynge, going throw SQL is not a good idea.

But to help with your current problem, you could try to use SELECTLATESTVERSION
https://docs.microsoft.com/en-us/dynamics-nav/selectlatestversion-function--database-

But it would hurt preformens

lynge

This is fundamentally the wrong way of inserting/updating data in NAV/BC - you should use webservices instead.
When that said, you can probably use this command: https://docs.microsoft.com/en-us/dynamics-nav/selectlatestversion-function--database-
...to fix it, but it will still be the wrong approach as it will hurt performance...

julkifli33

Hi Lynge, i have no choice
this one i push data from database A to Database B

if only 1 database, i can use Changecompany

SanderDk

@julkifli33,
Depending on you NAV version, you can actually use webservice between different NAV databases.

I will allways agree with @lynge, going throw SQL is not a good idea.

But to help with your current problem, you could try to use SELECTLATESTVERSION
https://docs.microsoft.com/en-us/dynamics-nav/selectlatestversion-function--database-

But it would hurt preformens

julkifli33

Hi SanderDk,
thanks for the advise.
Selectlatestversion works for me.
thank you so much !

julkifli33

Hi All
I have Added this code

trigger OnOpenPage()
    begin
        SelectLatestVersion();
        CurrPage.Update();
    end;

but when i drilldown i got this error message.


do i need this --> CurrPage.Update();
in my code

Thanks

SanderDk

No, not if you do not make changes to your data

julkifli33

Hi Sander,
i used this code in the page

trigger OnOpenPage()
    begin
        SelectLatestVersion();
        CurrPage.Update();
    end;

When i drilldown from jetreport, it supposed to open this page
but it will show error message

jacksoncharlie

I am not code but still I try to learn things from posts like here.