User login
|
|
|
|
Frontpage Sponsor
|
|
|
|
Baanboard at LinkedIn
|
|
|
Poll
|
What actions do you take to ensure compliance with the sanction/embargo lists published by the EU and the US? don't know what you are talking about 55% we are scanning customers, suppliers and employees using own programs on a regular basis 12% each delivery/purchase adress is checked immediately with own programs 2% we are using third party software for this purpose 10% we simply don't bother 20% Total votes: 49 |
|
|
|
query.extend.where(), query.extend.where.in.zoom()
|
|
By patvdv at 26 Feb 2008 - 21:57
|
|
query.extend.where(), query.extend.where.in.zoom()
Syntax
void query.extend.where( string extension_string [, mode] )
void query.extend.where.in.zoom( string extension_string )
Description
Use this to construct a query extension for the WHERE clause of a database query. Use query.extend.where() for non-zoom sessions. Use query.extend.where.in.zoom() for defining query filters for zoom sessions.
Arguments
|
extension_string
|
A string containing the names of the fields to be included in the WHERE statement. Use commas [,] to separate the field names.
|
|
mode
|
This optional argument can have one of the following values:
- EXTEND_OVERWRITE : replaces any existing query extension (this is the default mode)
- EXTEND_APPEND : appends this extension to the existing extension
|
Note
In BaanERP, this function replaces the predefined variable query.extension that was used in earlier versions of the software.
Context
You can use query.extend.where() in the before.program section of UI scripts and in the before.open.object() hook of DAL scripts. You can use query.extend.where.in.zoom() only in the selection.filter section of UI scripts.
Related topics
|
|
All times are GMT +2. The time now is 01:37.
