Hello,
I am new to baan 5. i have a doubt regarding query.extension.
where is query.extension written. is it in the dal script or the ui script?

Sandy

Sandy,

It can be written in both UI and DAL scripts.

Refer to the online tools programmer's manual -

SQL query extensions synopsis (http://www.baanboard.com/programmers_manual_baanerp_help_functions_sql_query_extensions_synopsis)
You can use query.extend.select() in the before.program section of UI scripts and in the before.open.object() hook of DAL scripts. You can use query.extend.select.in.zoom() only in the selection.filter section of UI scripts.