New post
Question
· Aug 10, 2017

autoExecute="false" is ignored; OnCreateResultSet and OnExecuteResultSet still run on page load

#ZEN #Caché

I have a <tablePane> element with OnCreateResultSet and OnExecuteResultSet methods; autoExecute is "false" but the OnCreateResultSet and OnExecuteResultSet methods are nevertheless called on page load.

I want the user to be able to press a button to submit the parameters, then have this button call tablePane.executeQuery() to execute the query.

autoExecute is simply igonored.  We're on 2014.1.3 with plans to upgrade to 2016 soon.

Are there more settings I need to set? Or is this attribute simply ignored?

 <tablePane id="tblReport" useSnapshot="true" autoExecute="false"
OnCreateResultSet="CreateRS" OnExecuteResultSet="ExecuteRS"
cellSpacing="8" showZebra="true"  showRowSelector="false" >

Thanks,

Laura

Discussion (5)1
Log in or sign up to continue
Laura Cavanaugh · Aug 11, 2017

I did not know that - but I tried taking it out, but my test global is still populated with method calls to OnCreateResultSet and OnExecuteResultSet methods.  The table itself if hidden at first.  In fact, there are multiple tablesPanes, and they are all getting called upon page load, even though the tablePane group is hidden.  

I'm going to play around with pInfo.QueryExecuted; and there's a runflag set up, which I can see why it was set up now.

THanks.

0 0