Simplicty and flexibility!


Execute Function / Derivation MemoExecDQL


Started by Graham Brown
Search
You will need to Sign In to be able to add or comment on the forum!

Execute Function / Derivation MemoExecDQL

What is the correct syntax to run a DQL Execstore  from Execute Function ?

MemoExecDQL(DQL0013,"","","","","")+Wait(0.1)+ DocumentClose()


Written by Graham Brown 22/10/14 at 13:23:46 Dataease [{8}]FIVE

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.


Written by DataEase 22/10/14 at 19:30:38 Dataease [{8}]FIVE
DG3_ForumList