Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th April 2018, 07:07
Premahari Premahari is offline
Member
 
Join Date: Mar 2018
Posts: 35
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
Updating serial number through dal
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)
C/S: None/Unknown

Hi iam trying to update serial from whinh226 to timfc010 through DAL. It's returning -12. On success It should return 0. can anyone please help. I have shared my code

Code:
select whinh226.cser:cser
    from whinh226
    where whinh226._index1 = {50,:orno,1,10,1,1,0}
    selectdo
        db.retry.point()
        dal.new.object("timfc010")
        dal.set.field("timfc010.koor",timfc.ord.sfc)
        dal.set.field("timfc010.pdno",orno)
        dal.set.field("timfc010.prsp",0)
        dal.set.field("timfc010.mitm",mitm)
        dal.set.field("timfc010.mser",cser)
        ret = dal.save.object("timfc010")
                            
        if ret = 0 then
              commit.transaction()          | commit transaction
        else
             dal.get.error.message(err.msg)     | get the last error message
             abort.transaction()          | abort transaction
             message(err.msg)              | display error message
        endif
        
        endselect

Last edited by bhushanchanda : 14th May 2018 at 15:14. Reason: added code tags
Reply With Quote
  #2  
Old 26th April 2018, 09:37
giggty's Avatar
giggty giggty is offline
Member
 
Join Date: May 2017
Posts: 51
giggty is on a distinguished road
Baan: Infor ERP 10.6 - DB: MSSQL Server 2008 R2 - OS: Windows Server 2012
So what is the actual error message?
Reply With Quote
  #3  
Old 27th April 2018, 06:21
Premahari Premahari is offline
Member
 
Join Date: Mar 2018
Posts: 35
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
Updating Serial NUmber

On success it should return 0. But it's returning -12, that means its not inserting that serial number. This is the error
Reply With Quote
  #4  
Old 27th April 2018, 07:44
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 490
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
Whats the value in the parameter "err.msg" ??
Reply With Quote
Sponsored Links
  #5  
Old 30th April 2018, 07:48
Premahari Premahari is offline
Member
 
Join Date: Mar 2018
Posts: 35
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
Updating serial Number

Hi,
I got an error of invalid value for serial number field.
Now I fixed that error. Its working fine Thank u very much
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
ue.before.after.destroy.object pralash Tools Development 7 19th January 2018 09:09
First and Last Serial Number of Particular Produciton Order hashirhabeeb Tools Development 3 20th October 2011 15:14
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
Serial number Veronica Project & Services 1 3rd September 2003 18:05
Serial Number generation in multi-occ forms Warans Tools Development 2 23rd December 2002 07:36


All times are GMT +2. The time now is 02:14.


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