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.

Changing mask format

2 posts in XML Last posting was on 2009-03-10 16:36:23.0Z
Mabel Posted on 2009-03-07 07:29:07.0Z
From: "Mabel" <mgfernandez@at4wireless.com>
Newsgroups: sybase.public.powerbuilder.xml
Subject: Changing mask format
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1933
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1933
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b22243$1@forums-1-dub>
Date: 6 Mar 2009 23:29:07 -0800
X-Trace: forums-1-dub 1236410947 10.22.241.152 (6 Mar 2009 23:29:07 -0800)
X-Original-Trace: 6 Mar 2009 23:29:07 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1815
Article PK: 814349

Hi,

I am using PB 9.0.1 Build 6533, my system operation is in spanish, comma for
decimal. I am trying to export in XML format but I need to use point for
decimal values without changing the system operation. I have tried to use
String() but it looks like that it does not work.

I need to get 15.18 instead od 15,18

Any idea.

Thanks in advance
Mabel


Dave Hauze Posted on 2009-03-10 16:36:23.0Z
From: "Dave Hauze" <david.hauze@steeldynamics.com>
Newsgroups: sybase.public.powerbuilder.xml
References: <49b22243$1@forums-1-dub>
Subject: Re: Changing mask format
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b69707$1@forums-1-dub>
Date: 10 Mar 2009 08:36:23 -0800
X-Trace: forums-1-dub 1236702983 10.22.241.152 (10 Mar 2009 08:36:23 -0800)
X-Original-Trace: 10 Mar 2009 08:36:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.xml:1816
Article PK: 814352

Mabel, have you tried creating a separate computed field (made invisible)
that converts it to 15.18 instead of 15,18 using some of the string
functions (like mid(), left(), right(), pos), and then point your XML
element to that computed field instead of the actual column? Doing this
should give you what you are looking for...

--
Dave Hauze

"Mabel" <mgfernandez@at4wireless.com> wrote in message
news:49b22243$1@forums-1-dub...
> Hi,
>
> I am using PB 9.0.1 Build 6533, my system operation is in spanish, comma
> for
> decimal. I am trying to export in XML format but I need to use point for
> decimal values without changing the system operation. I have tried to use
> String() but it looks like that it does not work.
>
> I need to get 15.18 instead od 15,18
>
> Any idea.
>
> Thanks in advance
> Mabel
>
>