Baanboard.com

Go Back   Baanboard.com > Blogs > jayasree's blog

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
13%
> 2000 GB
24%
Total votes: 80

Baanboard at LinkedIn


Reference Content

 
Beginner BaaN IV
By jayasree at 18 Oct 2019 - 19:36

Hi

I am a beginner in BaaN IV. i got error at runtime when trying to display multi occ session  by checking enum values in query.extension

query.extension="xxxx.yyy<>domainnme.segment domain.1.procr"

Is there any other way to do...

Thanks 

 

0
No votes yet

by bdittmar on October 20, 2019 - 9:57am
bdittmar's picture
Hello,

try one of these, i.g. query.extend.where.
Code:
BaanERP Programmers Guide

Send feedback about the online Help to Baan Development 
Query extensions 
--------------------------------------------------------------------------------
Query extensions define conditions that the 4GL engine adds to the SELECT, FROM, and/or WHERE clauses of a database query in order to minimize the number of fields read from the main table and in order to retrieve all reference table fields required by the UI and/or DAL scripts. 

BaanERP provides the following functions for constructing query extensions: 

query.extend.select() 
query.extend.select.from.in.zoom() 
query.extend.from() 
query.extend.from.in.zoom() 
query.extend.where() 
query.extend.where.in.zoom() 
You can program query extensions in the UI script and/or the DAL script. In the UI script, you program the extensions in the before.program or before.zoom sections. In the DAL script, you program the extensions in the before.open.object.set() hook. 

For a full discussion of query extensions, see SQL Query extensions.
Example:
Code:
query.extend.where(" (tisfc001.osta = tcosta.in.prod or tisfc001.osta = tcosta.active)", EXTEND_APPEND)
Regards


All times are GMT +2. The time now is 01:44.


©2001-2018 - Baanboard.com - Baanforums.com