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

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 84

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 3rd June 2016, 06:06
kingsley143's Avatar
kingsley143 kingsley143 is offline
Join Date: Feb 2008
Location: INDIA
Posts: 34
kingsley143 is on a distinguished road
Baan: Baan LN 6.1 - DB: Microsoft SQL server 2000 - OS: windows server 2003
Zoom to default value in ttadv4522s000 session.

A new blog entry has been added:

Zoom to default value in ttadv4522s000 session.

I am giving table name and field name  input seperatly on form. First I enter table name (e.g. tiitm001) as input to form  then I want to zoom to by default fields of that table.
I have given zoom of session ttadv4522s000(Display  table fields) to input  field  on form but when i zoom  it opens baolx001 table fields where as I am giving table value as tiitm001.
I want to dislpay fields of table which I am giving as input.
Kindly help.
Reply With Quote
Old 3rd June 2016, 10:10
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Join Date: Sep 2012
Location: India
Posts: 2,399
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix

Please post your code in the related forums and not as blogs.

You can try using selection filter for zooming to correct records.


Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Old 3rd June 2016, 16:26
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,422
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Bhushan is correct - post in a forum and if necessary moderators can move the post around to the appropriate forum. I never read blogs for issues. For you case you need to put more that a table name - the zoom should look something like this:
	ttadv422.cpac =	"ti"
	ttadv422.cmod = "pgc"
	ttadv422.flno = "001"
	ttadv422.vers = "B40U"
	ttadv422.rele = "c4"
	ttadv422.cust = "and1"
	last.msg =$("ttadv4522s000", Z.SESSION, "", "", 0)

This some quick code I put together once before - last message will contain a table name and a field name. Like tiitm001.item. When creating zooms like this look at the table and see what fields are in the primary index. In the case of this table you will also need to know the VRC it is in.

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
Sponsored Links
Old 4th June 2016, 14:09
Ajesh's Avatar
Ajesh Ajesh is offline
Join Date: Feb 2009
Posts: 649
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
Just try putting in before.zoom of the Table Fields field

   ttadv422.cpac = table.cpac
   ttadv422.cmod = table.cmod
   ttadv422.flno = table.flno
Assuming that this is done after you split the form field into table.cpac,table.cmod and table.flno.
Reply With Quote

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 to session and find record automatically timb25 Tools Development 11 25th April 2012 22:21
Handling Unit functionality baazigar Distribution, Transportation & Warehousing 4 19th February 2012 15:54
Zoom Session for selection bklunder Tools Development 1 27th November 2003 07:25
zoom to different session trchandra Tools Development 2 19th March 2002 03:58
Opening zoom session E.Toniolo Tools Development 6 21st February 2002 21:02

All times are GMT +2. The time now is 10:45.

©2001-2018 - -