Problem importing XML into a DataWindow

PB: 10.2

This is my first try at using XML. Our mainframe group has created a 
'WebService' whereby we can get the quantity in stock by passing stock code 
via GetURL. The result passed back is an XML string:

<?xml version="1.0" encoding="UTF-8"?>
<QyOnHand>15</QyOnHand>

I created an external DataWindow with a single column QyOnHand and made it 
numeric.

The following line of code returns -1

ll_rc = dw_1.ImportString(ls_xml, XML!)

What am I missing?

Thanks,
Roland 


0
Roland
9/29/2006 4:14:38 PM
sybase.powerbuilder.general 62418 articles. 19 followers. Follow

2 Replies
608 Views

Similar Articles

[PageSpeed] 55

You might want to try posting in the .webservices or .xml newsgroup.  ;)

"Roland Smith" <rsmith@cvps.com> wrote in message 
news:451d466e$1@forums-1-dub...
> PB: 10.2
>
> This is my first try at using XML. Our mainframe group has created a 
> 'WebService' whereby we can get the quantity in stock by passing stock 
> code via GetURL. The result passed back is an XML string:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <QyOnHand>15</QyOnHand>
>
> I created an external DataWindow with a single column QyOnHand and made it 
> numeric.
>
> The following line of code returns -1
>
> ll_rc = dw_1.ImportString(ls_xml, XML!)
>
> What am I missing?
>
> Thanks,
> Roland
> 


0
Jay
9/29/2006 5:07:30 PM
Arguments were backwards.

"Roland Smith" <rsmith@cvps.com> wrote in message 
news:451d466e$1@forums-1-dub...
> PB: 10.2
>
> This is my first try at using XML. Our mainframe group has created a 
> 'WebService' whereby we can get the quantity in stock by passing stock 
> code via GetURL. The result passed back is an XML string:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <QyOnHand>15</QyOnHand>
>
> I created an external DataWindow with a single column QyOnHand and made it 
> numeric.
>
> The following line of code returns -1
>
> ll_rc = dw_1.ImportString(ls_xml, XML!)
>
> What am I missing?
>
> Thanks,
> Roland
> 


0
Jay
9/29/2006 5:21:44 PM
Reply:

Similar Artilces:

DataWindow XML Import question / problem ?
Not sure if this is possible but just checking to make sure I am not missing anything !. I have created an XML template for a datawindow which maps all elements to their relative datawindow columns. This all works fine for importing XML which contains data dor all dw columns. I have tried importing an XML file with a subset of elements with the elements in the correct order that they occur in the template and this still works. However, should it be possible to import a subset of XML data with the elements occuring in a different order to the XML template ?. (if I do this then it ...

superreview requested: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 217751] (Av2) <general.xml>
Serge GAUTHERIE <gautheri@noos.fr> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 217751: (Av2) <general.xml> https://bugzilla.mozilla.org/attachment.cgi?id=217751&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> (In reply to comment #2) > Hmm, if the diff is current (by date I would imagine so) then I do not > personally see a problem syncing this and grabbing toolkits version fr...

superreview denied: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 217751] (Av2) <general.xml>
neil@parkwaycc.co.uk <neil@httl.net> has denied Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 217751: (Av2) <general.xml> https://bugzilla.mozilla.org/attachment.cgi?id=217751&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil@httl.net> >+ <binding id="statusbarpanel-menu-iconic" display="xul:menu" extends="chrome://global/content/bindings/general.xml#statusbarpa...

datawindow.import(XML!,"file.xml") syntax error
I am using Pocket PowerBuilder 1.5 build 360 from the help file I saw [ImportFile method (DataWindows)] long dwcontrol.ImportFile ( {saveastype importtype}, string filename {, long startrow {, long endrow {, long startcolumn {, long endcolumn {, long dwstartcolumn } } } } } ) This statement inserts all the data in the file D:\TMP\EMPLOYEE.CSV into dw_employee starting at the first column: dw_employee.ImportFile("D:\TMP\EMPLOYEE.CSV") This statement inserts all the data in the file D:\TMP\EMPLOYEE.XML into dw_employee starting at the first column: dw_em...

superreview granted: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 219626] (Av3-XPFE) <general.xml>++
neil@parkwaycc.co.uk <neil@httl.net> has granted Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 219626: (Av3-XPFE) <general.xml>++ https://bugzilla.mozilla.org/attachment.cgi?id=219626&action=edit ...

superreview requested: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 219626] (Av3-XPFE) <general.xml>++
Serge GAUTHERIE <gautheri@noos.fr> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 219626: (Av3-XPFE) <general.xml>++ https://bugzilla.mozilla.org/attachment.cgi?id=219626&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> Av3-XPFE-Bw, with full diff. Keeping [[ (Av3-XPFE-Bw) <general.xml>++ patch 2006-04-23 16:17 PDT 2.38 KB neil: review+ ]] ...

Problem with import of xml
Hello, I have exported a list of bugs from Bugzilla 3.6 (one machine). And tried to import this list on a newly installed Bugzilla 4.2 (other = machine). I get the following error: syntax error at line 1, column 0, byte 0 at = /usr/local/lib/perl5/site_perl/5.14.2/mach/XML/Parser.pm line 187 at importxml.pl line 1272 The XML file looks the following: <attachid>8</attachid> <date>2012-12-07 18:35:00 +0100</date> <delta_ts>2012-12-07 18:35:20 +0100</delta_ts> Line 1272 is the middle one. What can I do to finish the import? Do I h...

XML import problem
Hello, I'm struggling with a problem and I don't seem to find a solution. I'm new to XML and I read through this NG but in vain. I'm connecting to a web site to login. In return, I get some XML including a Key, GMTime, Expires and an Error or Alert. The Error or Alert fields are not always present in the answer, only if the login fails. This is the answer: <?xml version='1.0'?> <QRZDatabase xmlns="http://online.qrz.com"> <Session> <Error>Password Incorrect</Error> <Expires></Expires> <GMTime&g...

Importing XML into a datawindow
Suppose you have an xml file and you want to import that into a datawindow. Is there a way to create the template automatically? I mean, is there a mechanism that can create the template for you, or do you have to manually do this? thanks! joe As far as I know, manually is the only way though many have suggested this as an improvement (the ability to create the datawindow from a dtd). Anyone else have thoughts on the subject? Doug Porter DailyAccess Corporation "JG" <joseph.grantNOSPAM@assetpoint.com> wrote in message news:427150e9$1@forums-2-dub....

xml datawindow import
This is a multi-part message in MIME format. ---=_forums-1-dub4cab0dcf Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit using powerbuilder 11.5 hi, i have a external datawindow and xml template and try to import a xml file into the datawindow, but i got two records, instaead of one record. i want to see only one record, but with different address lines as addr1, addr2 etc The problem what i noticed is i have a addresline in the xml document, which is rpeating for more then one line with the same attribute. how to solve this porblem...

XML import problems
The other problem was Web service was returning a dataset. We made it to return XML. No it is fine. But i have question. When microsoft dataset generates XML it excludes any column that have null value. Due to this datawindow import is not working properly. This is reported problem from Micrsoft http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q317961 Does any one has solution for this? Thanks Rajendra Kulkarni wrote: > The other > problem was Web service was returning a dataset. We made it > to return XML. No it is fine. But i have question. When > micros...

Having problems importing XML
This is a multi-part message in MIME format. ---=_forums-2-dub41dd6ab1 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit The import XML on this datawindow was working, then it stopped working and I can't figure out why. Here is the srd, the text xml and trace file. All I get is: Invalid document structure D:\Work\eval_offline2\test_plist.xml, Line: 1, Position: 42. But every thing looks ok to me. I tried creating a new XML template but that had the same problem. Any help appreciated. Jim ---=_forums-2-dub41dd6ab1 Content-T...

Import XML into a DataWindow
Hi all, having never used DataWindow XML Import I wonder about the limitations of this technique. I have to import a XML file containing order headers and order items. So I thought I can achieve that using a grouped DataWindow but that seems to be wrong. Here is a shortened sample of the data I like to import: <?xml version="1.0" encoding="utf-8"?> <ORDER xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.healy-hudson.com/XMLSchema/Schlecker/1.1" xsi:sch...

Import XML to Datawindow
This is a multi-part message in MIME format. ---=_forums-1-dub4b059314 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit When I tried the import using the XML attached Import keeps failing. Please help as creating template is not successful either. Thanks ---=_forums-1-dub4b059314 Content-Type: text/xml; name="file4.xml" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="file4.xml" PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjxzOkVu dmVsb3BlIHhtbG5zOnM9Imh0dHA6Ly9zY2hlbWFzLnhtbH...

Web resources about - Problem importing XML into a DataWindow - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Appleā€™s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 12/7/2015 6:11:44 PM