>I need to pass a query parameter to a form. Problem with this is, the query needs to be executed in the Load() method, and the parameters being passed in aren't available until the Init() method. (I found a discussion similar to this, Thread #
242341 in July, but it didn't quite answer my question).
>
>I know there may be ways around this. I just now thought that maybe I could use a view in the DE set to "NoDataOnLoad", then rnu the query in init when the parameters are available. But I'm using SQL-PT and don't know if a remote view will mess this up.
>
>Or is there a SQL-PT way to create the empty cursor in the load, then run the query in Init()?
>
>The cursor must exist (even if it is empty) in the Load() of my form because I need to bind controls to it.
>
>Any suggestions would be appreciated!
You may use property of some object (e.g. application object) which is visible for both calling and called forms, e.g.
*** calling form code
oApp.registerX=myvalue
do form myform
*** called form (myform) load event
if oApp.registerX=...
*** run some code
endif
Edward Pikman
Independent Consultant