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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 20th September 2017, 17:06
Rupesh Khedekar's Avatar
Rupesh Khedekar Rupesh Khedekar is offline
Junior Member
 
Join Date: Aug 2011
Posts: 8
Rupesh Khedekar is on a distinguished road
Baan: ERP LN - DB: Oracle,MS Sql - OS: Windows
Arrow User Exit DLL does not restrict system from saving data.
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: None/Unknown

I have an User Exit DLL on tfacp200. I have added some simple business logic which is executing properly. Even though system sets an error message in the execution and returns dalhookerror, data is getting saved in the session.

I have tried below simple code to re-check:
function extern long ue.before.before.save.object(long mode)
{
on case mode
case DAL_NEW:
break
case DAL_UPDATE:
dal.set.error.message("gbacp300.03")
return(DALHOOKERROR)
endcase
return(0)
}

Even this does not restrict system from updating record.
Please help.

Thank You in advance!!
Reply With Quote
  #2  
Old 20th September 2017, 19:52
BaanInOhio BaanInOhio is offline
Senior Member
 
Join Date: Oct 2005
Location: Northeast Ohio
Posts: 180
BaanInOhio is on a distinguished road
Baan: Baan 4c4, 5C, LN - DB: Informix, Oracle, SQL - OS: HP UX, Win2K
Table tfacp200 probably doesn't have a DAL - in 10.2.1 it doesn't. Depending on your enterprise server level, the UE may not execute since the DAL is not present or the standard session uses db.update instead of dal.* to update the record.

Prior to ES 10.3.1 - UE DLL executed when table has a DAL referenced and dal.save used to update OR when table doesn't have DAL referenced and dal.save used to update. Not executed when table has a DAL referenced and db.update used to update OR when table doesn't have DAL referenced and db.update used to update.

The rules slightly changed in ES 10.3.1 onward where the UE DLL is also executed when db.update is used to update. More changes introduced in ES 10.5 where a UE DLL may not execute when the table has an extension present.

If you're using ES 10.4, you might want to check solution 1687005, where the DALHOOKERROR status was ignored and still updating the record.

You can check if tfacp200 uses a DAL by looking at the initial page in ttaad4100 after entering the table. "DAL not active" means it's present. "DAL not available" otherwise. Can also check the 'scripts' tab in the standard table definition.
Reply With Quote
  #3  
Old 21st September 2017, 09:04
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
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
Hi,

Are you sure it saves the data? Try changing some field like amount, save and then exit the session after you see the message and open it again. What value do you see on the amount field?

I tried it on 10.2.1 and it works fine. It does not revert the new value on the form after the error message, but it does not save the new value either. It does not let me update the field.

Please share your results.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #4  
Old 21st September 2017, 09:22
Rupesh Khedekar's Avatar
Rupesh Khedekar Rupesh Khedekar is offline
Junior Member
 
Join Date: Aug 2011
Posts: 8
Rupesh Khedekar is on a distinguished road
Baan: ERP LN - DB: Oracle,MS Sql - OS: Windows
Thank You guys for answering query.

@BaanInOhio, yes table tfacp200 has DAL. Solution you have mentioned is already installed on the server.

Hello Bhushan,

Yes system saves the data even after executing dalhookerror.

Regards,
Rupesh
Reply With Quote
  #5  
Old 21st September 2017, 15:13
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 444
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
return(DALHOOKERROR) should return non zero value, if the value of DALHOOKERROR is zero, the record will get saved,

If you want assign, DALHOOKERROR as -1 and then return the value

I am not sure about this but you could give it a try..
Reply With Quote
  #6  
Old 22nd September 2017, 07:42
ulrich.fuchs's Avatar
ulrich.fuchs ulrich.fuchs is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 514
ulrich.fuchs is on a distinguished road
Baan: IV, LN6.1 - DB: --- - OS: ---
Is your code executed at all? (Debugger is starting?) Most sessions will disable the DAL of tfacp200 and / or not make use of the DAL during inserts. So user exits on tfacp200 are usually not working: Either they don't get executed (older Enterprise server versions) or the will throw an error 205 making the session crash.

best regards
Uli
__________________

Dipl. Ing. Ulrich Fuchs
- ERP consulting and software development -
Widumestra├če 18 - 44787 Bochum - Germany
mail@ulrich-fuchs.de - www.ulrich-fuchs.de
http://all-in-for-erp.com (Blog zu Infor LN))
Reply With Quote
  #7  
Old 25th September 2017, 08:01
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 444
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
Best is just put it in debug in UI and check whats what??
Reply With Quote
  #8  
Old 26th September 2017, 06:43
DEVINDER ARORA DEVINDER ARORA is offline
Junior Member
 
Join Date: Jul 2002
Location: india, delhi
Posts: 5
DEVINDER ARORA is on a distinguished road
Baan: c4,5c, ERP LN - DB: SQL SERVER 2000 - OS: WIN2K3 SERVER
I also faced same issue few months back and fixed by installing latest tools solution. Log incident with Infor.
__________________
DEVINDER ARORA
Reply With Quote
Sponsored Links
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
Can you easily change field to 'read only' status ? metropoj Tools Development 7 8th September 2012 18:01
how do i block user from taking data from other warehouse Skumar Tools Administration & Installation 1 13th November 2011 11:17
BaanLogin works for local user, not for LDAP user bbomgardner Tools Administration & Installation 13 8th March 2009 19:52
AFS DLL of tdilc1122s000 is not working (Saving) rairai AFS/DDC/OLE: Function servers 1 17th June 2003 15:59


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


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