New Function in 8,1 - LabelExecDQL() - Execute the Script stored in a label (Ver. 8.1.0.1521)
We are rushing ahead and the full documentation will follow, but for those of you that have embraced the ExecDQL class have come across some challenges.
ExecDQL() the normal PRISM function is limited to 255 and if you want to write the DQL directly into the derivation you have been limited by the fact that a derivation in total cannot be bigger than 255 on top of the problem with ". DQL's rely heavily on the use of " in the syntax and as the derivation is a string, you immediately have a problem.
So the "default" and favored method of using ExecDQL() is to use the MemoExecDQL(). Here you can execute DQLs up to 64k but as the DQL need to be loaded in a Memo you will have to use the lookup "relationship" DQL where the key is a relational key into a table that store the DQL.
This is a very flexible way of using DQL, but sometimes it is nice to contain the code in the same form.
Here is where LabelExecDQL() comes into play. You can simply write the DQL into a label (which can be 4096 characters long) and then execute it in a derivation or on a button with LabelExecDQL().
So what about the "ugly" DQL in the form. Simply hide it with SetState().
Re:New Function in 8,1 - LabelExecDQL() - Execute the Script stored in a label (Ver. 8.1.0.1521)
Remember when calling a LabelExecDQL() that you are reading a GUI object not a PRISM column.
This means that the name of the object needs to be in "" ex. LabelExecDQL("MyDQL","","","","","")
You can rename a label by right-clicking on it and change the DEFINITION.