error -4 while importing xml in pb11.5

Importing XML files that can be uploaded in PB9 fail in PB11.5
when a computed string column is included in the SQL statement as '',
it restricts the imported values as size 0. If the computed column is
modified to let's say ' ' (5 spaces) then it allows up to 5 character
long strings to be imported for that field.
0
Aki
1/8/2010 11:09:07 AM
sybase.powerbuilder.xml 546 articles. 0 followers. Follow

2 Replies
445 Views

Similar Articles

[PageSpeed] 0

On Jan 8, 4:09=A0pm, Aki <akhil.ra...@gmail.com> wrote:
> Importing XML files that can be uploaded in PB9 fail in PB11.5
> when a computed string column is included in the SQL statement as '',
> it restricts the imported values as size 0. If the computed column is
> modified to let's say ' ' (5 spaces) then it allows up to 5 character
> long strings to be imported for that field.

Kindly provide me some solution to this issue..... thanks in advance :)
0
Aki
1/8/2010 11:11:03 AM
When you respond to your own message, you give folks the idea that
it's arlready been responded to and they skip it.  You might not want
to do that.

You need to do an edit source on the datawindow and modify the column
specification so that it sees the computed column as larger than the
default it assumed.

On Fri, 8 Jan 2010 03:11:03 -0800 (PST), Aki <akhil.rangi@gmail.com>
wrote:

>On Jan 8, 4:09�pm, Aki <akhil.ra...@gmail.com> wrote:
>> Importing XML files that can be uploaded in PB9 fail in PB11.5
>> when a computed string column is included in the SQL statement as '',
>> it restricts the imported values as size 0. If the computed column is
>> modified to let's say ' ' (5 spaces) then it allows up to 5 character
>> long strings to be imported for that field.
>
>Kindly provide me some solution to this issue..... thanks in advance :)
-----------------------------------

My Web 2.0 Stuff

Blog:      http://bruce.pbdjmagazine.com/
Facebook:  http://www.facebook.com/people/Bruce-Armstrong/1600223798
Fotki:     http://public.fotki.com/brucearmstrong/
LinkedIn:  http://www.linkedin.com/in/bruceaarmstrong
Twitter:   http://twitter.com/bruce_armstrong
YouTube:   http://www.youtube.com/user/brucearmstrong
0
Bruce
1/8/2010 3:00:29 PM
Reply:

Similar Artilces:

XML in, XML out
Hi All (and a happy holiday to those that will get a break), I am trying to read in an XML file of addresses. I need to remove all the address data from the file where code =~ /^000/ (there are none in the example data below). I need to reproduce that data 'as is', so I need to honour the tag structure, although the order of the tags doesn't need to be honoured. I have been trying to use XML::Simple and I had a go with XML::Smart but I haven't been able to get the results I want. My best effort is below (with XML::Simple). There are a couple of differences ...

XMl to XML
Hello,   I retrieved an XML from the dataset which retrieves data from the table in the database. I need to present the data  in a different structure. Is XSLT the way or are there any other options. please let me know. Thanks!! Yes XSLT is a good choice to convert xml file to other forms. You can take a look at XSLT Tutorial.Sincerely,Young Fang...

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...

XML Import Error
I created a simple dw and in the designer retrieved and saved rows as xml. When I try to import the rows, I get this error. XML Import Error - No matching datawindow column reference within XML template. Ay ideas? -- PB9.01.7151 Thank you, R.Chauvin Did you turn on the xml import tracing option? It should give you more information about what it doesn't like. On 2 Jul 2004 06:08:17 -0700, "Bob Chauvin \( Paix dehors \)" <nocanspambob_chauvin@yahoo> wrote: >I created a simple dw and in the designer retrieved and saved rows as xml. >...

PowerBuilder 11.5
I have an application that I am creating that accesses a web service designed by our customer and retrieves inventory/product/order information. I am getting the error "There was an error generating the XML document" on one of the calls to the web service. The process is that I call the function GetPickTickets and with a string argument that contains the store code. This returns an array of any open orders for that particular store. This works fine. After that I call another function UpdatePickTicket which acknowledges that we recieved the order information for a specif...

XML import error
Hi, I am using PB9 on Windows 2000 Professional. I am able to import xml containing Arabic characters from a file using ImportFile. But when I try to import an xml string containing Arabic characters using ImportString, it crashes. Please help. Thanks Be sure that the XML string is valid XML -- to verify, try to use PBDOM to create a document from that string, e.g.: PBDOM_Builder domBuilder PBDOM_Document doc TRY domBuilder = CREATE PBDOM_Builder doc = domBuilder.BuilderFromString( "<XML with Arabic characters here>" ) CATCH( PBDOM_Except...

Error importing from XML
Hi everybody, What I'm doing is to export data from a dynamic datastore to a XML file, until this point there's no problem. But when I try to import this data from the XML file in another dynamic datastore the error -11 appear to me. I have the xerces dll in my machine and with other data it works well, but I'm affraid that XML have some trouble with non-visual characters, just like new line character. Anyone can give me a hand in this? Thanks. Tiago wrote: > Hi everybody, > > What I'm doing is to export data from a dynamic datastore to a XML f...

XML import in powerbuilder
I am running into a weird problem. I am trying to call a webservice method that returns an XML string. Then I import it into a datawindow using importstring method. This is a customer query. When I query for a single record, it sends me valid XML that I can import, but when queried on multiple records, the xml generated is not being imported. Then I tried to craete a template for import process. When I do that, import returns me -1. I have compared the datatypes and order of fields with the XML elements, they all match. When I run the XML string through XMLParsestring() method, it retu...

superreview requested: [Bug 297814] Report XML parsing errors to the error (JS) console : [Attachment 186991] Report XML parsing errors to the console, rev. 1
Benjamin Smedberg [:bs] (formerly bsmedberg@covad.net) <benjamin@smedbergs.us> has asked Mike Shaver <shaver@mozilla.org> for superreview: Bug 297814: Report XML parsing errors to the error (JS) console https://bugzilla.mozilla.org/show_bug.cgi?id=297814 Attachment 186991: Report XML parsing errors to the console, rev. 1 https://bugzilla.mozilla.org/attachment.cgi?id=186991&action=edit ...

superreview granted: [Bug 297814] Report XML parsing errors to the error (JS) console : [Attachment 186991] Report XML parsing errors to the console, rev. 1
Mike Shaver <shaver@mozilla.org> has granted Benjamin Smedberg [:bs] (formerly bsmedberg@covad.net) <benjamin@smedbergs.us>'s request for superreview: Bug 297814: Report XML parsing errors to the error (JS) console https://bugzilla.mozilla.org/show_bug.cgi?id=297814 Attachment 186991: Report XML parsing errors to the console, rev. 1 https://bugzilla.mozilla.org/attachment.cgi?id=186991&action=edit ------- Additional Comments from Mike Shaver <shaver@mozilla.org> I don't _really_ like using nsScriptError for this, because of the JavaScript references in...

XML::Parser XML::DOM XML::XSLT
------_=_NextPart_001_01C6E0D0.3E27D77A Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hi Craig and fellow VMS Perlers, You last wrote about this Fri 3/16/2001 11:24 AM, not counting your very helpful comments on Eisner/Decuserve more recently. One of my colleagues sent me an email requesting that I make XML::XSLT=20 available on VMS. perl 5.8.6, VMS 7.3-2, DECC 7.1 latest ACRTL (version 3) on Alpha XML::XSLT (version 0.48) depends on XML::Parser (version 2.34). This depends on expat (version 2.0.0). I built expat a...

Re: Import xml file in xml Element
Here, I got one question, you might be able to help me.  Is it possible to import xml file in xml element? For example: <store>  <book>     <name>Harry Potter</name>     <version>5</version>     <publish>2007</publish>     <details>c:\actress.xml</details>   </book></store> -- c:\actress.xml <harry> <actor>Daniel Radcliffe</actor> <age>18</age> </harry> <Hermione&...

How to select Xml as Xml?
If I select Xml nodes like this from sql server; select xmlData.query('//Field[@F = "True"]') as extendedInfo from.... ..how to loop through the items in C#? I can't cast it to a System.Xml.XmlNodeList..? You can use the XmlDocument class.  There's a Load method and a LoadXml method.  One of these should get you what you want, after which you can select nodes as you need.C# <---> VB.Net Translator mm8: If I select Xml nodes like this from sql server; select xmlData.query('//Field[@F = "True"]') as extendedInfo from.... ...

XML Import Error #2
This is a very straightforward xml file. When I import in the dw painter it tells me import failed no rows. The mappings look OK. No errors in the trace file. I made all columns string types to avoid any possible format errors. I've tried all the suggestions from the NGs here and google. /*---------------------------------------------------*/ /* 4/5/2007 20:39 */ /*---------------------------------------------------*/ CREATING SAX PARSER. USING XML IMPORT TEMPLATE: shell_ntd XML NAMES MAPPING TO DATAWINDOW IMPORT COLUMNS: ELEMENT: /NTD/...

An error while importing an XML file
I made a datawindow for a external source. I made a xml template , and put this template on the data-import tab. When I run a preview in the datawindow painter, and import a file, all works fine. But in my windowsform application I want to import the xml file in my datawindow object with the code: dw_foutlog.ImportFile("E:\foutenlog.xml", Sybase.DataWindow.FileSaveAsType.Xml) When I run my application I get the following error: An unhandled exception of type 'Sybase.DataWindow.MethodFailureException' occurred in datawindow.dll Additional infor...

Web resources about - error -4 while importing xml in pb11.5 - sybase.powerbuilder.xml

Viral Channels: Hi5 Adds Contact Importing to App Invite Flow
... social networking platform I’ve seen, hi5 announced tonight that it is adding the ability for users to invite non-hi5 friends to apps by importing ...

YouTube - iPad importing photos from floppy disk.
You are using an outdated browser, which YouTube no longer supports. Since some features on YouTube may not work, you are viewing a lightweight ...

Tony Abbott considers importing US-style school program with private industry involvement
Tony Abbott is considering an unprecedented Americanisation of the school education system with radical changes that could see HECS-style fees ...

Importing fuel will prove better for the consumer
Importing fuel will prove better for the consumer

Sydney grandmother Lorn Cheng arrested for allegedly importing heroin in 252 pellets
Brenda filed a missing persons report last Friday, concerned that her mother hadn't returned from a holiday in Cambodia when she said she would. ...

Importing more fads from failed systems
Fast-tracking talented professionals into the classroom is yet another imported fad from England and the US - both of which are failed education ...

Mark Clermont sentenced to life in jail for importing drugs worth $260 million inside road roller
A judge has praised police for preventing cocaine and methylamphetamine with a street value of $260 million reaching the streets of Sydney and ...

Hong Kong man charged with importing 150kg of crystal methamphetamine into Sydney
A Hong Kong national is charged with importing 150 kilograms of ice following a joint-agency investigation in Sydney.

Man, 91, charged with importing cocaine hidden in soap boxes into Australia
A 91-year-old Sydney man has been charged with importing cocaine hidden in soap into Australia, prompting police to warn travellers to beware ...

Adobe updates Photoshop Express for Android with blemish removal tool, RAW importing, more
Adobe has actively been rolling out new and powerful tools for mobile platforms in recent months including Lightroom Mobile for iPad followed ...

Resources last updated: 11/30/2015 10:14:35 PM