Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wizardo
Creator III
Creator III

dynamicUpdate macro does not work! plz need urgent help

hi there,

i wanted to say for starter that the lack of PROPER documentation for the new qv9 dynamic update feature is really puzzling me, especially with all the Hype about it in the new version.

but back to business:)

i tried to mimick the operation of the macro that was written in vba in the sample excel file that comes together with the new CallCenter sample application, and write a similar macro that is run from one QVW document and updates a table in another QVW document.

and i don't seem to figure out why it isn't working.

if i use a button to run the macro then what happens is that it goes into the macro editor window and stops there on the line that says

" m_QvDoc.DynamicUpdateCommand(SQL)"

but it does not give any error

when i run this in the editor with "start debug" then sometimes it stops on the same line with an error:

"object required :m_QvDoc "

as if the opening of the 2nd QVW has failed. but when i click ok it presnts me with the 2nd QVW opend.

in either cases it does not preform the dynamic update into the table of the 2nd QVW

i have attached both files

i have turned on all the security option that prohibit macro from accessing the system and external files so this is not the problem

i probably am missing something really stupid here cause i really don't know why it isn't working

hope one of you can enlighten me.

if anyone knows about any form of documentation about the new feature (other then the callCenter sample or the few short lines in the API guide , I'm sure the entire community will be grateful

thanks

Mansyno Aka wizardo

10 Replies
flavio_fazzano
Partner - Creator
Partner - Creator

Yes George, in the lef file you should see a line saying

DYNAMIC_UPDATE;YES;;

F!