Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

2 Replies
Not applicable

Re: Auto Refresh with ODBC connection oracle db

Any idea?

bluishjoe
Not applicable

Re: Auto Refresh with ODBC connection oracle db

DynamicUpdateCommand has nothing to do with it. It is used inside macros to modify records that you have currently loaded in QlikView and has no effect on the DB.

If you want to programmatically refresh data from DB I'd try

ActiveDocument.DoReload

which returns true in case of success.