Auto Refresh with ODBC connection oracle db

[#1]

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]

Any idea?

[bluishjoe]

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.