Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > AFS/DDC/OLE: Function servers

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th October 2018, 22:36
Alfonso Monsalv Alfonso Monsalv is offline
Newbie
 
Join Date: Oct 2012
Location: Canada
Posts: 2
Alfonso Monsalv is on a distinguished road
Baan: Baan IV c4 / Infor-LN - DB: Informix/Oracle - OS: UNIX
How I can execute a command in Infor-LN ?

Hi everybody:
How I can execute a command from the program script in Infor-LN ?

See details:
I have a program script that I need to execute a command from the program script code.
I want a process a Warehosing Order.

Do you know how to do it ?

My code Below:
Code:
function process.warehousing.order()
|this function process the Warehousing Order if the header status is not received .
{
    err.msg = ""
    stpapi.put.field("whinh2100m100", "whinh200.oorg", str$ (whinh200.oorg))
    stpapi.put.field("whinh2100m100", "whinh200.orno", str$ (whinh200.orno))
    stpapi.put.field("whinh2100m100", "whinh200.oset", str$ (whinh200.oset))
    afs_ret = stpapi.find("whinh2100m100", err.msg)
    if afs_ret = 1 then
             stpapi.form.command("whinh2100m100", 5, "automatic.process", err.msg)                |call the process function from this session
            if not isspace(err.msg) then                                                               |--Error Message  Location does not Exist
                rprt_send()
            else
                err.msg = "Order Not Process / Lines not found for the Warehousing Order "
                rprt_send()
            endif
            stpapi.end.session("whinh2100m100")                                                    

        stpapi.end.session("whinh2100m100")                                                     
    else
        err.msg = "Warehousing Order not Found in the table "
        rprt_send()
    endif
}

Last edited by mark_h : 9th October 2018 at 14:12. Reason: add code tags for readability
Reply With Quote
Sponsored Links
  #2  
Old 9th October 2018, 14:17
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well can't really help since we are 4c4, but one of the things they do recommend for LN is using DAL2 functionality. You can try searching in this forum for how to do that.

From just glancing at the code I do not see any glaring issues. Does it find the record? Or where exactly is the error occurring?
__________________
Mark

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
  #3  
Old 9th October 2018, 22:01
Alfonso Monsalv Alfonso Monsalv is offline
Newbie
 
Join Date: Oct 2012
Location: Canada
Posts: 2
Alfonso Monsalv is on a distinguished road
Baan: Baan IV c4 / Infor-LN - DB: Informix/Oracle - OS: UNIX
Thank you very much.
I will do it with DAL.
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
Execute Query ailisee Tools Development 3 31st March 2011 09:46
DEM - Can a normal user be authorized for 'Execute SQL Query' session? syarragu DEM & Workflow 4 8th September 2010 14:21
Execute an script from an external server mjpedreira1 Tools Administration & Installation 2 30th July 2009 08:46
How to execute .sql file containing query in Baan rajbptl Tools Development 4 30th July 2008 21:30


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


©2001-2018 - Baanboard.com - Baanforums.com