Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

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
11%
> 2000 GB
24%
Total votes: 79

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th October 2019, 21:45
jayasree jayasree is offline
Newbie
 
Join Date: Oct 2019
Location: india
Posts: 1
jayasree is on a distinguished road
Baan: BaaN - DB: SQL - OS: windows
Beginner BaaN IV

A new blog entry has been added:

Beginner BaaN IV

Quote:
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 
Reply With Quote
  #2  
Old 20th October 2019, 11:57
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,823
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
query extensions

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
__________________
//Bernd

Last edited by bdittmar : 21st October 2019 at 10:24. Reason: Example added
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
e-Ventus Baan Users Newsletter - Enjoy! Carl Gonzalez General Discussion & Chat 0 14th May 2007 18:09
BaaN - 114 , Baan Roles . Spain - Transacciona C. andres77 Jobs and Resumes 0 20th January 2006 01:07
Ervaren Baan specialist ICT Builder Jobs and Resumes 3 5th February 2005 07:37
Invitation to SSA Global's BaaN User Group Meeting in Bangkok nopadon ไทยฟอรัม 0 12th January 2005 20:25


All times are GMT +2. The time now is 09:22.


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