I am using a datawindow in the IDE of 11.2 to manipulate
some data that comes to me in a tab separated text file.
I have set up an external datawindow with the correpsonding
column specifications (one being the "Date of Birth")
I can successfully import the data using the "Rows - Import"
but my problems arise when doing a "Save Rows As..." to
another text file.
My date format is "dd/mm/yyyy" but when 05/04/1993 is saved
to the text file the leading zero is removed.
It looks like the "Save As" is using my system date format
which is "d/mm/yyyy" but I can't (and don't want) to change
this to the "dd/mm/yyyy" format.
I have tried using edit masks and format options for the
field but it just seems to get ignored.
Anybody got any hints?
Thanks in advance
Subject: Using Save Rows As Text and date formats - Zero is removed
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 7 Jul 2008 21:43:53 -0700
X-Trace: forums-1-dub 1215492233 10.22.241.41 (7 Jul 2008 21:43:53 -0700)
X-Original-Trace: 7 Jul 2008 21:43:53 -0700, 10.22.241.41
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87328
Article PK: 416584
Subject: Re: Using Save Rows As Text and date formats - Zero is removed
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Date: 23 Jul 2008 09:52:03 -0700
X-Trace: forums-1-dub 1216831923 10.22.241.152 (23 Jul 2008 09:52:03 -0700)
X-Original-Trace: 23 Jul 2008 09:52:03 -0700, vip152.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87439
Article PK: 416695
The editmasks and formats are presentation settings and aren't considered
when exporting data. The system formatting is used for exporting. If you
want to use the built-in SaveAs functionality then you're stuck with the
system formatting. Alternatives are to write your own code for the export or
export from PB to Excel and from Excel to a text file.