Problem with '.' and ',' in a PB application ...

Hi,

The problem is:

We have a PB application using Informix. This application makes a lot of
calculations. This application works fine on some PC but very badly on
others PC.
- Where it works fine, the decimal symbol in the parameters configuration of
windows NT is '.' (dot)
- Where it does'nt work, the decimal symbol in the parameters configuration
of windows NT is ',' (comas)

The application is running for a while.

The question is  :
Is there a way to force the application to use the '.'  (dot) symbol
whatever the configuration of the PC ('.' (dot) or ',' (comas)) without
modifying all the code? (ie: when it is 52,21 the application should
interpret this as 52.21)
Do I have something to do at the level of the Informix database ?

Thanks for your time and your answers.

Damien S.
dasimon@capgemini.fr



0
D
10/22/1999 2:39:26 PM
sybase.powerbuilder.general 62418 articles. 17 followers. Follow

4 Replies
863 Views

Similar Articles

[PageSpeed] 29

You can temporarily set the regional settings then set the back.
HKEY_CURRENT_USER\Control Panel\International
Either sDecimal or sMonDecimalSep


D Simon wrote:

> Hi,
>
> The problem is:
>
> We have a PB application using Informix. This application makes a lot of
> calculations. This application works fine on some PC but very badly on
> others PC.
> - Where it works fine, the decimal symbol in the parameters configuration of
> windows NT is '.' (dot)
> - Where it does'nt work, the decimal symbol in the parameters configuration
> of windows NT is ',' (comas)
>
> The application is running for a while.
>
> The question is  :
> Is there a way to force the application to use the '.'  (dot) symbol
> whatever the configuration of the PC ('.' (dot) or ',' (comas)) without
> modifying all the code? (ie: when it is 52,21 the application should
> interpret this as 52.21)
> Do I have something to do at the level of the Informix database ?
>
> Thanks for your time and your answers.
>
> Damien S.
> dasimon@capgemini.fr

--
Kenneth A. Drendel
ICQ# 34027019
Kdrendel@hotmail.com


0
Ken
10/22/1999 3:01:34 PM
I had a similar problem.
PowerBuilder wil recognize your regional settings, and you should not have
problem regardles of decimal symbol.
Make sure that you do not convert yours decimals to string somewhere in your
calculations.

Hepek

by the way, check the new PowerBuidler Framework at: http://www.hepek.com/




D Simon <dasimon@capgemini.fr> wrote in message
news:vZ51PqJH$GA.213@forums.sybase.com...
> Hi,
>
> The problem is:
>
> We have a PB application using Informix. This application makes a lot of
> calculations. This application works fine on some PC but very badly on
> others PC.
> - Where it works fine, the decimal symbol in the parameters configuration
of
> windows NT is '.' (dot)
> - Where it does'nt work, the decimal symbol in the parameters
configuration
> of windows NT is ',' (comas)
>
> The application is running for a while.
>
> The question is  :
> Is there a way to force the application to use the '.'  (dot) symbol
> whatever the configuration of the PC ('.' (dot) or ',' (comas)) without
> modifying all the code? (ie: when it is 52,21 the application should
> interpret this as 52.21)
> Do I have something to do at the level of the Informix database ?
>
> Thanks for your time and your answers.
>
> Damien S.
> dasimon@capgemini.fr
>
>
>


0
Hepek
10/22/1999 4:52:00 PM
As I know, there is NOT a way to solve this problem.

0
Alexander
10/24/1999 9:40:02 AM
Hi Ken & Damien,

IMHO, that is not an option because that change will affect all running
applications at that time. We have these (international) problems too. I
would only inform the users that the current regional settings are not valid
for this application and that they have to change them theirselves. The real
problem is that the application is already built without knowing about this
problem. If you knew that this problem existed, you could solve it in many
ways by converting commas to decimal points. Anyway, as long as you as
storing the data always the same way (using decimal points), PB displays it
prefectly, using the current regional settings.

--
Met vriendelijke groet,

- Eric Aling [TeamSybase], Cypres Informatisering bv, The Netherlands
  Eric's Home & PB Site @ http://www.knoware.nl/users/cypr115

Ken Drendel <Kdrendel@hotmail.com> wrote in message
news:38107C4E.58D0DC76@hotmail.com...
> You can temporarily set the regional settings then set the back.
> HKEY_CURRENT_USER\Control Panel\International
> Either sDecimal or sMonDecimalSep
>
>
> D Simon wrote:
>
> > Hi,
> >
> > The problem is:
> >
> > We have a PB application using Informix. This application makes a lot of
> > calculations. This application works fine on some PC but very badly on
> > others PC.
> > - Where it works fine, the decimal symbol in the parameters
configuration of
> > windows NT is '.' (dot)
> > - Where it does'nt work, the decimal symbol in the parameters
configuration
> > of windows NT is ',' (comas)
> >
> > The application is running for a while.
> >
> > The question is  :
> > Is there a way to force the application to use the '.'  (dot) symbol
> > whatever the configuration of the PC ('.' (dot) or ',' (comas)) without
> > modifying all the code? (ie: when it is 52,21 the application should
> > interpret this as 52.21)
> > Do I have something to do at the level of the Informix database ?
> >
> > Thanks for your time and your answers.
> >
> > Damien S.
> > dasimon@capgemini.fr
>
> --
> Kenneth A. Drendel
> ICQ# 34027019
> Kdrendel@hotmail.com
>
>


0
Eric
10/24/1999 11:48:05 AM
Reply:

Similar Artilces:

''''''''''''''''''''
Name: haznen Email: haznenatyahoodotcom Product: Gran Paradiso Alpha 8 Summary: '''''''''''''''''''' Comments: '''''''''''''''''''''''''''''''''''' Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061204 UGES/1.7.2.0 GranParadiso/3.0a1 From URL: http://www.mozilla.org/projects/granparadiso/ Note to readers: Hendrix gives...

'''''
Name: mario Email: ramar17atfastwebnetdotit Product: Gran Paradiso Alpha 2 Summary: ''''' Comments: K: Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2) Gecko/20070206 GranParadiso/3.0a2 ...

'do' won't 'do' if '/'
Greetings to All from Au, Have a NetWare Perl 5.8.4 and wanted to tweak File\Spec\NW.pm to try and standardise on '/' separators. If I run a test script (t/uni/lower.t) with an unmodified NW.pm, it calls t/uni/case.pl, that, in case.pl, (when the path separators are '\'), the $file is '..\lib\unicore\To\Lower.pl' and the following code portion works, with $simple getting a returned table: sub casetest { my ($base, $spec, $func) = @_; my $file = File::Spec->catfile(File::Spec->catdir(File::Spec->updir, "lib", &qu...

'''
Name: L Lachowsky Email: e2brutus_10atyahoodotcom Product: Firefox Summary: ''' Comments: why duddn this surprise me... I change default server from IE to Mozilla, and then i get error messages. well, shud I decide to not get on my computer with Mozilla..or shud I risk security breeches with IE....hmmm at least i can get on the internet with IE Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this fee...

Cast from type ''''DBNull'''' to type ''''String'''' is not valid.
How do I avoid getting this error: Cast from type ''''DBNull'''' to type ''''String'''' is not valid. I am trying to get values from the database into a form for updating using a Datareader, SQL is set to allow nulls for certain fields as they are not required but the only way I can get the form to display is by adding a space in SQL. Is there another way around this? Check if it is equal to DBNull.Value first and if it is, don't do the cast.Stanley Tan theSpoke Blog Where in the code does it need to go? I am using the following and it's the profile that isn't always requi...

table_info('','','','%') cannot return any types
I was recently confirming table_info special cases and discovered the case for getting table_types cannot work. table_info('','','','%') should return a list of table types but it returns a list of empty strings instead: my @types = $h->tables('', '', '', '%'); print "all types:\n", join("xxx\n", @types), "\n"; # should output something like: # "dbo" # "INFORMATION_SCHEMA" # "sys" # and actually outputs: xxx xxx It seems to be down to the following ...

'or' or 'union'
Hello I was just wondering, in general what is better to use, an 'or' clause in a select or a 'union' to join two selects together. Do both statements create work tables? Many thanks Alex I think OR will be better than union. because suppose u have 3 tables and using OR u can join table a and table b and table c so each table will have only one read. but using union you will join table a and table b and in another query of union u will use table (a or b) and table c so ur one read is more in union . Ramdas Alex Cheung wrote: > Hello > >...

'b'..'a'
Hello. I'm using defferent 5.6.0's for Win32. I wonder wheter following behaviour is intentional or not: d:\>perl -e "print 'b'..'c'" bc d:\>perl -e "print 'b'..'a'" bcdefghijklmnopqrstuvwxyz I expected empty list in latter case, like in perl -e "print 'bb'..'a'" <!ENTITY Vadim REALLIFE "Vadim V.Konovalov, St.Petersburg, Russia"> &Vadim; On Wed, Sep 20, 2000 at 03:14:41PM +0400, Konovalov, Vadim wrote: > Hello. > > I'm using defferent 5.6.0'...

'IN' Clause or 'OR'
Hello, [1]: select * from TABLEA where COL1 IN('value1','value2''valu3'....) [2]:select * from TABLEA where COL1 = 'value1' OR COL1= 'value2' OR COL1='valu3'. TABLEA is a huge table and it has non-clustered index on COL1. Among the above 2 queries, which query will give me the better performance or fast response and WHY? What is the difference between 'IN' and 'OR' clauses as for as Sybase Optimization is concerned. Which is the better one to be used on huge tables. Thanks. Mac An IN list is treated ...

EXEC sp_msforeachtable 'sp_spaceused ''?'''
What does the following SQL code mean?  EXEC sp_msforeachtable 'sp_spaceused ''?'''Johan TheunissenMCPD, MCSE, MCTS BizTalk 2006==============================Please mark the most helpful reply/replies as "Answer". JohanNL:sp_msforeachtable This is the name of the SP that resides in the master database.  This SP executes one or more commands for a table. JohanNL:sp_spaceused This is the command that you want to run for each of the tables residing in your current database.  As you might have understood so far, that this is again a...

'Value' should be between 'minimum' and 'maximum'.
I'm attempting to invoke with parameters:  Dim thing2 As New mydelsubPBStep(AddressOf pbStep) Me.Invoke(thing2, "setMax", dt.Rows.Count)      <---- this is where the error occurs   the delegate looks like this: Private Delegate Sub mydelsubPBStep(ByVal mode As String, ByVal value As Integer)   the function it's calling looks like this:Private Sub pbStep(ByVal mode As String, ByVal value As Integer) Select Case mode.ToLower Case "clear" ProgressBar1.Value = 0 Case "step" ProgressBar1.PerformStep() L...

'To', 'CC', & 'BCC'
Name: Dick Tracy Email: philipdottracyatoptusnetdotcomdotau Product: Thunderbird Summary: 'To', 'CC', & 'BCC' Comments: I have just started using Thunderbird and while I find it quite excellent- I suggest having a button to add addressees to 'BCC' as well. Currently each 'BCC' addressee has to be selected manually. I send e-mail to quite a number of people at a time and I do not wish to readily spread others addresses easily. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0....

Ambiguity between '_fastcall Application()' and 'Forms::Application'
Hi, (repeating a question first asked in another group) I have converted a lot of forms etc. from BCB5 to CB2009, and I created a small project each time to get that done, per form. All worked nicely. I now, after all preparations, took the big plunge, created a new project in CB2009 and added all files etc. Now, for all these VCL modules that use Application (for instance Application->ProcessMessages()) I get this error: [BCC32 Error] *.cpp(110): E2015 Ambiguity between '_fastcall Application()' and 'Forms::Application' Any idea why that is ? And how...

LINQ -- how to do where x in ('a', 'b','c')
How do I write a LINQ expression that does the following: select * from SomeTable where SomeColumn in ('a', 'b','c')  Jay There is no IN operator in LINQ (yet), but you can use Contains instead: http://www.devauthority.com/blogs/jwooley/archive/2007/08/06/69922.aspx Jos...

Web resources about - Problem with '.' and ',' in a PB application ... - sybase.powerbuilder.general

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Second visa application 'likely' to be approved
The family of a terminally ill Pakistani student can 'hopefully come to Australia sooner rather than later' says Immigration Minister Peter Dutton. ...

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

Tashfeen Malik's visa application under scrutiny - Business Insider Deutschland
The US government has released the visa application for Tashfeen Malik, who along with her husband killed 14 people in an attack in San Bernardino, ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

Lawmaker: Immigration Officials Didn’t Fully Vet Tashfeen Malik’s Visa Application
"It’s unacceptable that U.S. Citizenship and Immigration Services did not fully vet Malik’s application and instead sloppily approved her visa," ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

Visa application of San Bernardino shooter released
CNN Visa application of San Bernardino shooter released CNN (CNN) The visa application of one of the San Bernardino shooters was released ...

ZTE to develop smartphone application processors in house
ZTE has stepped up its efforts to internally develop smartphone chipset solutions, aiming to re-capture the title as one of the top-three smartphone ...

Resources last updated: 12/28/2015 6:32:09 PM