Second attempt for this entry.

I am trying to create a button to call a DQL saved in ExecDQLStore under DQlNr 001

MemoExecDQL( any ExecDQLStore with (DQLNr = "001") ,"" ,"","" ,"" ,"") .

Hi Graham.

You can't use ANY in a derivation. When using MemoExecDQL in a form you need to first lookup the DQL you want to use in a Virtual Memo and then execute it.

This is a Data/Programming crossover where you store the DQL's as data in you app, and then execute them on the fly.

So what you need is a Key Field which identify which DQL you want to lookup ex. DQLNr with Derivation "001" and tjhen a virtual MEmo field called ex. DQL with derivation: Lookup ExecDQLStore DQL

You can then put the following on your button:
MemoExecDQL(DQL,"","","","","") 

If you want to use the same setup to run other DQLs in the same form, simply use following derivation on your button:

SetValue("DQLNr")+wait(0.1)+MemoExecDQL(DQL,"","","","","")