Hi all,

I would like to know if is possible to run a DQL procedure or another code ( EXECDQL, MemoEXECDQL) , for example over night, automatically, without an operator interaction.

In fact, the goal is set a time, and run the code automatically ( job scheduling task ) .

Thanks in advance

Afonso

Yes. There is a Timer() event on the Form Object in OML.


This is a global event so when used it will be global so no point using different timer() events but rather have one form with it and the event will be executed 10 times a second.

You can use this for controlling anything in an application. There are some known problems with this as DE code is not re-entrant so one have to be careful with what one exectute - try to avoid using Actions etc. 

You can call a ExecDQL or a normal DQL from here.

The only requirment is that the app is open and that the form is open.

There are functions in GetCurrent()/SetCurrent() for checking the status of DE and to activate it if that is necesssary for the execution of your procedure.