2 Replies Latest reply: Oct 19, 2011 5:07 AM by Mirco Andreon RSS

    Auto Refresh with ODBC connection oracle db

      Hi all,


      I just started to use QlikView, i would like to know how cqn i do the auto refresh of the database. I searched by internet and i looked at that i can add this sentences in the QV script (edit script icon):


      sub update

           set Result = ActiveDocument.DynamicUpdateCommand ("UPDATE * SET TABLE1")

      end sub


      sub Insert

           set Result = ActiveDocument.DynamicUpdateCommand ("INSERT  INTO TABLE1")

      end sub


      sub Delete   

           set Result = ActiveDocument.DynamicUpdateCommand ("DELETE FROM TABLE1")

      end sub

       

      is there anything wrong? do i have to put this script in the edit script of QV? could you help me?

      Best Regards,

      Raul