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!