Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th June 2002, 12:48
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Unconfirmed User
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
query.extend.select

hi all
how can i use query.extend.select, query.extend.from , query.extend.where, i am getting compilation error
please help
regards
gaurav
Reply With Quote
  #2  
Old 18th June 2002, 13:59
FransG's Avatar
FransG FransG is offline
Member
 
Join Date: May 2002
Posts: 67
FransG is on a distinguished road
Baan: BaanERP - DB: Oracle - OS: Unix
The syntax is as follows:
query.extend.select(select string, [mode])
query.extend.from(from string, [mode])
query.extend.where(where string, [mode])

In the strings you can put the select/from/where part of your query.
The mode is an optional argument. It has the following values:
EXTEND_OVERWRITE replaces any existing query extension.
EXTEND_APPEND appends the extension to the existing extension.

EXTEND_OVERWRITE is the default value for mode.

Hope this helps.
__________________
Regards,
Frans
Reply With Quote
  #3  
Old 18th June 2002, 14:15
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Unconfirmed User
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
it is not working

Hi Frans
I tried it but it is giving compilation error "unresolved reference to function". i am using it in before.program section.
gaurav
Reply With Quote
Sponsored Links
  #4  
Old 18th June 2002, 16:46
FransG's Avatar
FransG FransG is offline
Member
 
Join Date: May 2002
Posts: 67
FransG is on a distinguished road
Baan: BaanERP - DB: Oracle - OS: Unix
Question

That's no problem using query.extend in the before.program section.
Please, send a copy of your code and the exact error message.
What type of session are you working on?

Thanks.
__________________
Regards,
Frans
Reply With Quote
  #5  
Old 18th June 2002, 16:47
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
What version of BaaN?

Gaurav,
These functions query.extend.select, query.extend.from , query.extend.where, I don't think are available in all versions of BaaN. As far as I know, in BaaN IV, you only have query.extension.

Thanks,
NS
Reply With Quote
  #6  
Old 24th January 2017, 11:18
Peter IJpema Peter IJpema is offline
Newbie
 
Join Date: Nov 2007
Posts: 2
Peter IJpema is on a distinguished road
Baan: Baan IV-C4 - DB: Oracle - OS: Unix
Extra info for ERPLN environments

Make sure the variables used in the query.extend are of the type external.

Example of subsession related to and called from tccom4120s000:

declaration:
table ttdpur904 | Own-table
external domain tccom.bpid import.bpid | Import from other session

before.program:
import("tccom120.otbp", import.bpid)
query.extend.where("tdpur904.otbp = :import.bpid")


Result: if the imported business partner exists in table ttdpur904 it will display as first line (single line) depending on the sub-session-type.
Reply With Quote
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 Off
HTML code is Off
Forum Jump


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


©2001-2017 - Baanboard.com - Baanforums.com