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 9th December 2016, 16:06
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 573
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Red face Setting query.extention of any standard session
Baan: Baan IVc4
C/S: Both

Hello everyone,

I want to set query.extention of standard session (say tiitm0101m000). So that, when the session is started, it will filter and display records based on query.extension.

How can I do it ?

Vishal
Reply With Quote
  #2  
Old 9th December 2016, 19:18
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,929
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Do you own source code? If you do all you have to do is in the before.program section add the query.extension code. Below is sample code we have in one session - when you zoom from the tiudi session it creates a filter on the session. If you do not have source code then you need to look at a source extender option.

Code:
	if prog.name$ = "tiudi4102m000" then
		query.extension = "tirou001.cwoc <> " & chr$(34) & "ZZZ" & chr$(34) & " and tirou001.kowc <> 3"
	endif
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 12th December 2016, 10:04
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 573
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
HI mark,

We do not own source code. Any other way around ?

Vishal
Reply With Quote
Sponsored Links
  #4  
Old 12th December 2016, 11:44
sachinbaan's Avatar
sachinbaan sachinbaan is offline
Senior Member
 
Join Date: Oct 2013
Posts: 166
sachinbaan is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: Microsoft Server
Hello,
You can give try to "Before.zoom"
field.f.item:
Before.zoom:
tiitm001.kitm = tckitm.manufacture
OR

You can create one session with main table tiitm001, there you can give query.extension.
__________________
Regards,
Sachin

TO DREAM THE PERSON U WOULD LIKE 2 B, IS 2 WASTE THE PERSON U R.
Reply With Quote
  #5  
Old 12th December 2016, 14:34
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,929
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Depending on what you are doing like sachinbaan recommends. Create your own session. You can use the forms from tiitm0101m000, just give it your own name. Of course this would work best for display only. Otherwise look at ~vamsi's source code extender in the code and utilities session.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Zoom on standard tools session in BAAN IVc4 swapnilj Tools Development 3 10th November 2014 17:44
Zoom Menu Return Multi Value layswan Tools Development 3 24th July 2012 10:42
Can I put my own customized session in Specific menu of a standard session? simona Tools Development 3 27th October 2009 18:34
Copy Baan Standard Session mr_suleyman Tools Development 6 21st September 2005 12:53
tfacp9450m000 FIBU Brush Up Kai's Forum Users Deutsches Forum 1 16th November 1999 01:00


All times are GMT +2. The time now is 13:34.


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