
Execute Function / Derivation MemoExecDQL
Execute Function / Derivation MemoExecDQL
What is the correct syntax to run a DQL Execstore from Execute Function ?
MemoExecDQL(DQL0013,"","","","","")+Wait(0.1)+ DocumentClose()
Re:Execute Function / Derivation MemoExecDQL
What is the correct syntax to run a DQL Execstore from Execute Function ?
MemoExecDQL(DQL0013,"","","","","")+Wait(0.1)+ DocumentClose()
ExecDQLStore is just a table and you only use it because you need a place to save/edit the DQLs.
MemoExecDQL() simply execute the DQL script stored in a Memo. So to execute a DQL from the Table ExecDQLStore (could be any table name like Jonny or MyDQLs) you need to create a relationship between the form where you want to use it and ExecDQLstore and then lookup the DQL into a virtual Memo in the form where you want to use it.
If the DQL is looked up into the field DQL then you can execute it from anywhere in that table simply by executing. MemoExecDQL(DQL,"","","","","").
If you want to execute a number of different DQLs in the same form all saved in the table ExecDQLStore you simply change the relationship key with SetValue().
If the Relationship Key ex. is DQLNr. then you do the following.
SetValue("DQLNr","0013")+wait(0.1)+MemoExecDQL(DQL,"","","","","")
you can then on another button ex. exevute DQL nr 0015.
SetValue("DQLNr","0015")+wait(0.1)+MemoExecDQL(DQL,"","","","","")
etc
You can of course also transfere data-entry values via the 4 data-entry fields etc.