Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

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: 2

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 3rd April 2020, 09:26
dorleta's Avatar
dorleta dorleta is offline
Senior Member
 
Join Date: Dec 2001
Location: Madrid - Spain
Posts: 136
dorleta is on a distinguished road
Baan: BaanIV - DB: All - OS: All
Get field value from xml

Hi
From one ION dataflow I want to write to a database.
from the Database connection point I call to a store procedure

EXEC update_opportunity @xmlData='[Data]';
message sync.quote

In the store procedure I try to get in variables the quote and opportunity value
What am I doing wrong?
I don´t get any value

Thanks
/**
[dbo].[update_opportunity] (@xmlData as XML)

SET NOCOUNT ON;
DECLARE @XmlDocumentHandle int;
declare @qono as varchar(9);
declare @qtno as varchar(9);

EXEC sp_xml_preparedocument @XmlDocumentHandle OUTPUT,
@XmlData;

set @qono =(SELECT ID
FROM OPENXML (@XmlDocumentHandle,
'Quote/QuoteHeader/DocumentID/ID',2)
)

set @qtno = (SELECT ID
FROM OPENXML (@XmlDocumentHandle,
'Quote/QuoteHeader/OpportunityReference/DocumentID/ID',2)
)
Reply With Quote
  #2  
Old 3rd April 2020, 17:32
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,444
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
Is this the right code for your stored procedure?

Are you able to compile it successfully?

Did you tried passing the XML data in SQL Server(I assumed)/Oracle directly?

You can also try something like this -

Code:
set @qono =(SELECT *
FROM OPENXML (@XmlDocumentHandle,
'Quote/QuoteHeader/DocumentID/ID',2) WITH (ID varchar(9) 'text()')
)

set @qtno = (SELECT *
FROM OPENXML (@XmlDocumentHandle,
'Quote/QuoteHeader/OpportunityReference/DocumentID/ID') WITH (ID varchar(9) 'text()')
)
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
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
Generic solution for writing XML files from Baan en@frrom Tools Development 1 11th April 2011 10:53
Compilation Error baansavvy Tools Development 4 20th April 2010 16:25
default cursor on form field Agus Mujtahid Tools Development 9 29th October 2009 12:13
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
Form Field Order Eddie Monster Tools Development 3 23rd August 2006 19:58


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


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