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

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 11th June 2020, 15:18
LK-Lie LK-Lie is offline
Join Date: May 2020
Posts: 2
LK-Lie is on a distinguished road
Baan: BaaN IV - DB: Informix - OS: Windows 10
Add manual UI filter - BaaN IV
Baan: Baan IVc4
C/S: Client


I have an issue with a multi-occurrence session.
The session's main table is : tisfc001.
And I want to add a filter on the session.
The filter includes a query extension on a table which contains the fabrication order.
So this is the link between the two tables.
But in the database definition there is no indexes between the tables.
And I can't modify the database structure.
Therefore, in the query by form there is no field from the other table.

I added two text boxes which contain the filter limits.
And I tried to modify the session's script.
I wrote this part :

function display.sort()
	domain tcbool exist
	exist = true
	if  NOT ISSPACE(seri.from) AND NOT ISSPACE( then
		exist = seri.exist()
		if exist then
			query.extension = "tisfc001.pdno IN (SELECT lhlmb132.pdno FROM lhlmb132 WHERE lhlmb132.seri INRANGE :seri.from AND"
		query.extension = "tisfc001.pdno NOT IN (SELECT lhlmb132.pdno FROM lhlmb132)"
	if exist then
I call the function when I click on a button.

The code doesn't work properly.
Sometimes the UI is totaly blocked and there are no more occurrences.
So you need to close the session and reopen it.
This issue was reduced by using seri.exist() to ensure that there is always data to display but it doesn't seem perfect at all...

Moreover when you add a query by form filter it's well executed.
If you remove it the query by form filter will disapear.
But if you click on the button the old query by form filter will be executed.

Can someone help me on this issue ?

My goal is to filter session's records with the query by form filter and the UI filter that I have added.

Reply With Quote
Sponsored Links
Old 12th June 2020, 09:07
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Join Date: Sep 2012
Location: India
Posts: 2,450
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
The first thing you can try is -

query.extend.where = "tisfc001.pdno IN (SELECT lhlmb132.pdno FROM lhlmb132 WHERE lhlmb132.seri INRANGE " & quoted.string(seri.from) & " AND " & quoted.string(


Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Old 25th June 2020, 14:29
LK-Lie LK-Lie is offline
Join Date: May 2020
Posts: 2
LK-Lie is on a distinguished road
Baan: BaaN IV - DB: Informix - OS: Windows 10
Hello bhushanchanda,

Thank you for your response.

I tried to use your code part.
But it gives me an error : unsolved reference.
So I have added the dll : ottdllstring.
But it doesn't change anything.

Do you have any other idea ?

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
BaanERP book J-Christ General Discussion & Chat 34 29th August 2013 11:51
Sr. Baan Administrator rstouffer Jobs and Resumes 6 15th September 2010 11:03
Interview with Jan Baan in an Indian Magazine bamnsour General Discussion & Chat 1 24th September 2007 14:11
BaaN - 114 , Baan Roles . Spain - Transacciona C. andres77 Jobs and Resumes 0 20th January 2006 00:07
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44

All times are GMT +2. The time now is 17:00.

©2001-2018 - -