Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th February 2002, 17:11
mzbella's Avatar
mzbella mzbella is offline
Junior Member
 
Join Date: Jan 2002
Posts: 10
mzbella is on a distinguished road
Help! Remote update of sales order lines

I am trying to find away to change the quantity on a sales order line from a custom session. Anyone have any thought on the best way to do this and insure that enerything gets updated? I am using IVc4.

Thank you.

Michael Z
Reply With Quote
  #2  
Old 19th February 2002, 17:30
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,929
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
What I usually do

Hi Michael!

This may not be the best answer for you - but it is what I usually do. Just to make sure that all the correct tables get updated I usually use the stpapi commands to run a Baan session to do the update. So in my custom session I might have some function server code to use a Baan session to perform the update on the table that I want. This gives me that "warm" and "fuzzy" feeling that all of the correct tables are being updated.

Maybe not the best solution, but we do not own source code. I know by using auditing and traces we could find all the tables to be updated, but this method is quicker for me.

Good Luck!

Mark
Reply With Quote
  #3  
Old 19th February 2002, 17:36
mzbella's Avatar
mzbella mzbella is offline
Junior Member
 
Join Date: Jan 2002
Posts: 10
mzbella is on a distinguished road
Thank you for your responce.

I am not sure what you mean by "stpapi commands". This sounds like what I am looking for I am just not sure how to pull in off.

Thanks.
Reply With Quote
  #4  
Old 19th February 2002, 18:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,929
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Attached documents

I am attaching what few documents I have about writing function server type code. You can search the tools forum for "stpapi" and get a lot of info.

Mark
Attached Files
File Type: zip api.zip (63.2 KB, 47 views)
Reply With Quote
  #5  
Old 19th February 2002, 21:13
mzbella's Avatar
mzbella mzbella is offline
Junior Member
 
Join Date: Jan 2002
Posts: 10
mzbella is on a distinguished road
Thanks Mark.

This is exactly what I am looking for.

Warm and Fuzzy feeling. mmmmm!!!
Reply With Quote
Sponsored Links
  #6  
Old 19th February 2002, 21:24
popeye's Avatar
popeye popeye is offline
Senior Member
 
Join Date: Oct 2001
Location: CA, USA
Posts: 149
popeye is on a distinguished road
My two cents ...

Even if u have the source code, Function Servers is a good solution esp for complex sessions like Sales Orders etc.

Here are the advantages:
1. Developer(s) need not spend time studying the logic of the Maintain session.
2. Even if the code changes for the Maintain Session (customizations etc), the session using the Function Server is not
affected. This is a blessing ... esp at a client where they keep adding in customizations.
3. Sessions performing complex tasks can be developed in a jiffy.

Disadvantages:
1. Slow ... Hence I prefer to use it for process sessions where the
user is not waiting for the session to complete.
2. Users get a hang of it and come up with weird requirements

Hope this helps.
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
Sales Order Lines manasrpadhi AFS/DDC/OLE: Function servers 2 21st September 2011 14:11
calculate net rate & amount in Sales Order Lines veyant AFS/DDC/OLE: Function servers 2 16th July 2004 09:27
Archiving of Sales Order Data kclewley Archiving & Multisite 6 21st January 2003 13:00
Function server dll for Sales Order Lines mgakhar AFS/DDC/OLE: Function servers 3 13th November 2002 19:59
Deleting Sales order lines noorulhaq Distribution, Transportation & Warehousing 4 9th October 2002 12:48


All times are GMT +2. The time now is 11:25.


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