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

julkifli33julkifli33 Member Posts: 1,073
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?

Best Answers

Answers

  • julkifli33julkifli33 Member Posts: 1,073
    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
  • julkifli33julkifli33 Member Posts: 1,073
    Hi SanderDk,
    thanks for the advise.
    Selectlatestversion works for me.
    thank you so much !
  • julkifli33julkifli33 Member Posts: 1,073
    edited 2019-08-15
    Hi All
    I have Added this code
    trigger OnOpenPage()
        begin
            SelectLatestVersion();
            CurrPage.Update();
        end;
    

    but when i drilldown i got this error message.
    d1zc4hjjivhj.png

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

    Thanks
  • SanderDkSanderDk Member Posts: 497
    No, not if you do not make changes to your data
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • julkifli33julkifli33 Member Posts: 1,073
    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
  • jacksoncharliejacksoncharlie Member Posts: 11
    I am not code but still I try to learn things from posts like here.
Sign In or Register to comment.