topic Re: Auto Refresh with ODBC connection oracle db in QlikView

Auto Refresh with ODBC connection oracle db

Tue, 07 Jun 2011 15:50:28 GMT

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

Re: Auto Refresh with ODBC connection oracle db

Fri, 10 Jun 2011 08:13:11 GMT

Any idea?

Re: Auto Refresh with ODBC connection oracle db

bluishjoe — Wed, 19 Oct 2011 08:09:26 GMT

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.