Baanboard.com

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

User login

Frontpage Sponsor

Main

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

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th June 2020, 15:18
LK-Lie LK-Lie is offline
Newbie
 
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

Hello,

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 :

Code:
|%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
function display.sort()
|%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
{
	domain tcbool exist
	exist = true
	
	if  NOT ISSPACE(seri.from) AND NOT ISSPACE(seri.to) then
		exist = seri.exist()
		
		if exist then
			query.extension = "tisfc001.pdno IN (SELECT lhlmb132.pdno FROM lhlmb132 WHERE lhlmb132.seri INRANGE :seri.from AND :seri.to)"
		endif
	else
		query.extension = "tisfc001.pdno NOT IN (SELECT lhlmb132.pdno FROM lhlmb132)"
	endif
	
	if exist then
		rebuild.query()
		execute(find.data)
	endif
}
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.

Regards
Reply With Quote
Sponsored Links
  #2  
Old 12th June 2020, 09:07
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
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 -

Code:
query.extend.where = "tisfc001.pdno IN (SELECT lhlmb132.pdno FROM lhlmb132 WHERE lhlmb132.seri INRANGE " & quoted.string(seri.from) & " AND " & quoted.string(seri.to)
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 25th June 2020, 14:29
LK-Lie LK-Lie is offline
Newbie
 
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 ?

Regards
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
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 - Baanboard.com - Baanforums.com