Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dw.ImportFile inserts an empty row

2 posts in DataWindow Last posting was on 2009-07-06 11:50:46.0Z
Thorsten Kummer Posted on 2009-07-02 08:42:05.0Z
From: Thorsten Kummer <thorsten.kummer@gmx.de>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: dw.ImportFile inserts an empty row
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a4c72dd$3@forums-3-dub.sybase.com>
Date: 2 Jul 2009 01:42:05 -0700
X-Trace: forums-3-dub.sybase.com 1246524125 10.22.241.152 (2 Jul 2009 01:42:05 -0700)
X-Original-Trace: 2 Jul 2009 01:42:05 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89578
Article PK: 418767

Hi all,

I've exported a bunch of datawindows to XML via dw.SaveAs().
If a dw has no rows the xml looks like this:


<?xml version="1.0" encoding="UTF-16LE" standalone="no"?>

<QPP_REP_MAP_DEFINITIONS/>


Beside XML Header data it contains only the dw.Table name, no rows or
columns etc.

When I import it using dw.ImportFile it contains an empty (a new) row.
How to avoid this? Is it a bug?
I did not code a dw.InsertRow(). I want it to have no rows after ImportFile.

PB 11.5, Build 3050 in Win XP

Best regards
Thorsten


Chris Pollach Posted on 2009-07-06 11:50:46.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a4c72dd$3@forums-3-dub.sybase.com>
Subject: Re: dw.ImportFile inserts an empty row
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a51e516$4@forums-3-dub.sybase.com>
Date: 6 Jul 2009 04:50:46 -0700
X-Trace: forums-3-dub.sybase.com 1246881046 10.22.241.152 (6 Jul 2009 04:50:46 -0700)
X-Original-Trace: 6 Jul 2009 04:50:46 -0700, vip152.sybase.com
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89591
Article PK: 418780

Have you tried the new and latest Maintenance Release - PB 11.5.1?

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Thorsten Kummer" <thorsten.kummer@gmx.de> wrote in message
news:4a4c72dd$3@forums-3-dub.sybase.com...
> Hi all,
>
> I've exported a bunch of datawindows to XML via dw.SaveAs().
> If a dw has no rows the xml looks like this:
>
>
> ?<?xml version="1.0" encoding="UTF-16LE" standalone="no"?>
>
> <QPP_REP_MAP_DEFINITIONS/>
>
>
> Beside XML Header data it contains only the dw.Table name, no rows or
> columns etc.
>
> When I import it using dw.ImportFile it contains an empty (a new) row.
> How to avoid this? Is it a bug?
> I did not code a dw.InsertRow(). I want it to have no rows after
> ImportFile.
>
> PB 11.5, Build 3050 in Win XP
>
> Best regards
> Thorsten