It is possible to programm query extensions in DAL or in UI-Script. What I don't find in documentation is the priority or sequence how this processed from Baan? Is it possible or makes it any sense, if you place code in both scripts?

Kind regards
Richard

Hi,

I think it will depend totally on where exactly you are writing the code. Like If you write a query extension code in "before.program" of UI and some other query.extension code in DAL's "before.open.object.set" then in this case DAL will get priority as here DAL's function will get executed later and it will append or overwrite the before.program's query.extension code.

I had not tried this but just putting my point on the basis of logical thinking :)

Regards,
Gaurav

It is possible; the conditions of the query.extend included in DAL are appended to the ones included in before.program. This is because the before program is executed before of the before.open.object() hook.

It is allowed in DAL but not in DAL2 (ERP LN6.1)
See the SQL query extension overview in the last help (programmers guide 7.6.0).

Regards
Philippe

Hi all,

thanks for your support. I programmed an additional query.extension in before.program. Originally there was one in the DAL.
I realised that in the GUI-script, because this query should only be active for this session, a display session.

Kind regards
Richard