SV: Programmatically change the number format?

[wangel--- via 4D_Tech]

Thanks Chip
I will try it out.
--

Message: 1
Date: Mon, 16 Mar 2020 17:17:04 -0400
From: Chip Scheide <4d_o...@pghrepository.org>
To: 4d_tech@lists.4d.com
Subject: Re: AW: Programmatically change the number format? 
Message-ID: <20200316171704131062.e0cec...@pghrepository.org>
Content-Type: text/plain; charset=iso-8859-1

it is simplest to define the format in the structure under formats and filters 
giving the format a name like "MyNumericFormat"

then in code you can simply refer to the format as "|MyNumericalFormat"
NOTE: the pipe (vertical bar) in front of the name.

this way you can use the same format throughout the system, and if your needs 
change you can change it in one place and not have to search all over the 
system for, and change every occurrence of the format, where you to simply type 
the format inline (in your code directly).


Chip


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SV: Programmatically change the number format?

[wangel--- via 4D_Tech]

Thank you, Olivier and Kirk. Got It working now, thanks to you two.
Very much appreciated.



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: AW: Programmatically change the number format?

[Chip Scheide via 4D_Tech]

it is simplest to define the format in the structure under formats and filters 
giving the format a name like "MyNumericFormat"

then in code you can simply refer to the format as "|MyNumericalFormat"
NOTE: the pipe (vertical bar) in front of the name.

this way you can use the same format throughout the system, and if your needs 
change you can change it in one place and not have to search all over the 
system for, and change every occurrence of the format, where you to simply type 
the format inline (in your code directly).


Chip
> Hi,
> 
> I suppose you want to display noting (or a special value, e.g. "-") 
> if the value is zero?
> 
> Defining a number format has the following pattern: "positive 
> values{;negative values};{zero}".
> 
> Example: "### ### ### ###.00;-### ### ### ###.00;-"
> 
> In other words: you just need to define one display format, no need 
> to apply an other display format for zero values.
> 
> HTH,
> 
> Olivier
> 
> || https://flury-software.ch/
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von wangel--- 
> via 4D_Tech
> Gesendet: Sonntag, 15. März 2020 20:10
> An: 4d_tech@lists.4d.com
> Cc: wan...@online.no
> Betreff: Programmatically change the number format? 
> 
> In a listbox with a selection of records I have some columns with numbers.
> They have the number format 0.00. Not all the cells have numbers 
> greater than 0, so is it possible to programmatically change the 
> format to #.## in cell where the number is 0?
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

AW: Programmatically change the number format?

[Olivier Flury via 4D_Tech]

Hi,

I suppose you want to display noting (or a special value, e.g. "-") if the 
value is zero?

Defining a number format has the following pattern: "positive values{;negative 
values};{zero}".

Example: "### ### ### ###.00;-### ### ### ###.00;-"

In other words: you just need to define one display format, no need to apply an 
other display format for zero values.

HTH,

Olivier

|| https://flury-software.ch/

-Ursprüngliche Nachricht-
Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von wangel--- via 4D_Tech
Gesendet: Sonntag, 15. März 2020 20:10
An: 4d_tech@lists.4d.com
Cc: wan...@online.no
Betreff: Programmatically change the number format? 

In a listbox with a selection of records I have some columns with numbers.
They have the number format 0.00. Not all the cells have numbers greater than 
0, so is it possible to programmatically change the format to #.## in cell 
where the number is 0?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Programmatically change the number format?

[Kirk Brooks via 4D_Tech]

You treat each of the column objects separately. So let's say your columns
are named "col_1", "col_2" and so on. (This is the object name.)
Use OBJECT SET FORMAT to manage the formatting from there.
https://doc.4d.com/4Dv17/4D/17.4/OBJECT-SET-FORMAT.301-4882942.en.html

On Sun, Mar 15, 2020 at 12:09 PM wangel--- via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> In a listbox with a selection of records I have some columns with numbers.
> They have the number format 0.00. Not all the cells have numbers greater
> than 0, so is it possible to programmatically change the format to #.## in
> cell where the number is 0?
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
==
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Programmatically change the number format?

[wangel--- via 4D_Tech]

In a listbox with a selection of records I have some columns with numbers.
They have the number format 0.00. Not all the cells have numbers greater
than 0, so is it possible to programmatically change the format to #.## in
cell where the number is 0?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

High Sierra number format problems

[Paul Lovejoy via 4D_Tech]

Hi,

We’re using v15 on High Sierra for a few of our clients. We’ve noticed an issue 
on some Macs that have been upgraded to High Sierra. Those machines have a 
number format displayed in 4D which is not what we’re seeing in the System 
Preferences. For example, the system prefs have “,” as the thousand separator 
and “.” as the decimal separator but in 4D we’re getting “.” as the thousand 
separator and “,” as the decimal separator.

So the system prefs would show 1,250.45 but 4D is showing 1.250,45. We have a 
system that detects the system preferences and sets the number format so it 
displays correctly. What is weird is that it’s as if the System Preferences 
number format pane is not actually setting the Mac OS X internal number format 
correctly. We’ve tried resetting it, resetting the PRAM etc. Nothing seems to 
work. This is happening on 2 machines out of 10 that have High Sierra. The 
others work fine.

Has anyone seen this?


Cheers,


Paul


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[stardata.info via 4D_Tech]

Using this format ###,##0;###,##0-; the number 0,85 is not displayed.



Il 04/10/2017 16:53, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 5
Date: Tue, 03 Oct 2017 18:28:36 -0400
From: Jeremy French<jeremyfre...@mac.com>
To: 4D iNUG Technical<4d_tech@lists.4d.com>
Subject: Re: Number format
Message-ID:<0840df29-2c31-48e3-8be5-400c3a5fd...@mac.com>
Content-Type: text/plain;   charset=utf-8

The pattern to control the display of a zero value has 3-parts, separated by a 
semicolon. Note the 2-semicolons:

positive_format;negative_format;zero_format

To display nothing for a zero value, put nothing after the second semi-colon.

So this display filter will show positive and negative numbers, but display 
nothing for a zero value when the object doesn’t have focus:

###,##0;-###,##0;




On Oct 3, 2017, at 5:59 PM, stardata.info via 4D_Tech<4d_tech@lists.4d.com>   
wrote:

In one listbox, i need to display a number format so if the value is zero not 
display anything.
I try to insert the format ###.##0,##0 but not work properly.




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[Roger Reed – Illus House via 4D_Tech]

There is a contradiction between your two messages:
>> the format ###.##0,##0
> the value: 0,85
That format cannot display those digits for that value. If you’re using a 
non-English system, the best you can expect is to see is 0,850
In either case, this isn’t a “zero value” unless you’re talking about an 
individual digit, in which case, you already know to use “#”, not “0”.
Thirdly, if there is no typo, this is an unusual numerical format to have two 
placeholding zeroes. Check two things: which language standard is your system 
using to format numbers, and which language standard is 4D using to format 
numbers?

Roger

> On Oct 4, 2017, at 08:15, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Jeremy,
> 
> I know this and i try, but not work.
> This format not display the value: 0,85
> 
> Thanks
> /Ferdinando/
> 
> Message: 5
> Date: Tue, 03 Oct 2017 18:28:36 -0400
> From: Jeremy French<jeremyfre...@mac.com>
> To: 4D iNUG Technical<4d_tech@lists.4d.com>
> Subject: Re: Number format
> Message-ID:<0840df29-2c31-48e3-8be5-400c3a5fd...@mac.com>
> Content-Type: text/plain; charset=utf-8
> 
> The pattern to control the display of a zero value has 3-parts, separated by 
> a semicolon. Note the 2-semicolons:
> 
> positive_format;negative_format;zero_format
> 
> To display nothing for a zero value, put nothing after the second semi-colon.
> 
> So this display filter will show positive and negative numbers, but display 
> nothing for a zero value when the object doesn’t have focus:
> 
> ###,##0;-###,##0;
> 
> 
> 
>> On Oct 3, 2017, at 5:59 PM, stardata.info via 4D_Tech<4d_tech@lists.4d.com>  
>> wrote:
>> 
>> In one listbox, i need to display a number format so if the value is zero 
>> not display anything.
>> I try to insert the format ###.##0,##0 but not work properly.
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[Koen Van Hooreweghe via 4D_Tech]

Space is not needed. But comma and point make a difference in US of EU notation.

Koen

> Op 4 okt. 2017, om 16:24 heeft Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> That's the way I've always been able to make it work - with the space for
> the zero condition.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[Koen Van Hooreweghe via 4D_Tech]

> Op 4 okt. 2017, om 14:15 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I know this and i try, but not work.
> This format not display the value: 0,85

> ###,##0;-###,##0;

Ferdinando,

This depends on your regional settings and the 4D compatibility settings.
From one of the recent 4D versions (v13 and higher) uses by default US 
notation, but converts automatically to display in your regional settings.

The provided format is imho a us format for displaying whole positive and 
negative numbers up to one hundred thousand. No zeroes.

You must add placeholders for the decimals. Eg: ###,###0.00;-###,##0.00; or 
###,##0.##;-###,##0.##; if you don't want to see 100,00 but 100.

In full European notation you might need to switch dot and comma: 
###.###0,00;-###.##0,00

See: design reference chapter filters and formats for more info 
(http://doc.4d.com/4Dv15/4D/15.4/Filter-and-format-codes.300-3285353.en.html)

HTH
Koen



Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[Kirk Brooks via 4D_Tech]

That's the way I've always been able to make it work - with the space for
the zero condition.

On Wed, Oct 4, 2017 at 7:16 AM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> Try "###.##0,##0;-###.##0,##0; "
>
> Note that (I think) you need a space after the second semicolon.


-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[Tom Dillon via 4D_Tech]

Ferdinando wrote:

>I try to insert the format ###.##0,##0 but not work properly.

Jeremy was right, except that he didn't notice you are using "." for thousands 
and "," for decimal. (I think)

Try "###.##0,##0;-###.##0,##0; "

Note that (I think) you need a space after the second semicolon.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[stardata.info via 4D_Tech]

Hi Jeremy,

I know this and i try, but not work.
This format not display the value: 0,85

Thanks
/Ferdinando/

Message: 5
Date: Tue, 03 Oct 2017 18:28:36 -0400
From: Jeremy French<jeremyfre...@mac.com>
To: 4D iNUG Technical<4d_tech@lists.4d.com>
Subject: Re: Number format
Message-ID:<0840df29-2c31-48e3-8be5-400c3a5fd...@mac.com>
Content-Type: text/plain;   charset=utf-8

The pattern to control the display of a zero value has 3-parts, separated by a 
semicolon. Note the 2-semicolons:

positive_format;negative_format;zero_format

To display nothing for a zero value, put nothing after the second semi-colon.

So this display filter will show positive and negative numbers, but display 
nothing for a zero value when the object doesn’t have focus:

###,##0;-###,##0;




On Oct 3, 2017, at 5:59 PM, stardata.info via 4D_Tech<4d_tech@lists.4d.com>  
wrote:

In one listbox, i need to display a number format so if the value is zero not 
display anything.
I try to insert the format ###.##0,##0 but not work properly.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Number format

[Jeremy French via 4D_Tech]

The pattern to control the display of a zero value has 3-parts, separated by a 
semicolon. Note the 2-semicolons:

positive_format;negative_format;zero_format

To display nothing for a zero value, put nothing after the second semi-colon.

So this display filter will show positive and negative numbers, but display 
nothing for a zero value when the object doesn’t have focus:

###,##0;-###,##0;



> On Oct 3, 2017, at 5:59 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> In one listbox, i need to display a number format so if the value is zero not 
> display anything.
> I try to insert the format ###.##0,##0 but not work properly.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Number format

[stardata.info via 4D_Tech]

Hi All,

I'm using 4D v15 on windows.
In one listbox, i need to display a number format so if the value is 
zero not display anything.

I try to insert the format ###.##0,##0 but not work properly.

Someone know how i can do.

Thanks
Ferdinando
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: European number format

[Koen Van Hooreweghe]

Hi Pat,

Maybe I missed it, but which 4D version are you using?

The 'Use period and comma as placeholders in numeric formats' is a 
compatibility setting for upgraded databases from v13 (or maybe from v12).
If you don't have this pref, the db was created a newer version and the setting 
is default on.

In old 4D versions you had to provide a number format for decimal point or 
comma. Eg "###,##0.00" for US and "###.##0,00" for us (I mean us, belgian ;-)
But if the compatibility setting is on (or in newer database), 4D does an 
automatic conversion. This means you have to always use the decimal point 
notation format, but the resulting string will be in the OS notation.

I just tested in a brand new v15 db on my OS, which is using decimal comma.

$number:=12345678.99//as of v15 the decimal point is also used in the method 
editor; beware dates have to be written as !-MM-DD!
$format:="###,###,##0.00"
alert(string($number;$format))

When I run this, the alert shows: 12.345.678,99

Have you tried to set the sepator values to a fixed value in your script:
vDecSep:="."
vThousandSep:=","
...

HTH
Koen (decimal comma guy)

Op 21-okt.-2016, om 11:16 heeft Pat Bensky <pben...@gmail.com> het volgende 
geschreven:

> So the number format string seems to be correct, and the first test is
> correct, but WHY are we getting all those < in the second test?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: European number format

[Pat Bensky]

I've modified my test script a bit:

  // testNumberformatting
C_TEXT(tMessage)
GET SYSTEM FORMAT(Decimal separator;vDecSep)
GET SYSTEM FORMAT(Thousand separator;vThousandSep)
fr_NumFormat:="###"+vThousandSep+"###"+vThousandSep+"###"+vThousandSep+"###"+vThousandSep+"###"+vThousandSep+"###"+vDecSep+"00"
fr_number:=(Records in table([data_15])*459)/2.3
tMessage:="Numformat: "+fr_NumFormat+Char(13)
tMessage:=tMessage+"1: "+String(fr_number)+Char(13)
tMessage:=tMessage+"2: "+String(fr_number;fr_NumFormat)+Char(13)
AlertMessage (tMessage)


When I run it on my (UK) system I get:
Numformat: ###,###,###,###,###,###.00
1: 258237.3913043478387
2: 258,237.39


When my client runs it on his Italian system he gets:

Numformat: ###.###.###.###.###.###,00
1: 25983,39130434782783
2: <<<<<<<<<<<<<<<<<<<<<<<<<

So the number format string seems to be correct, and the first test is
correct, but WHY are we getting all those < in the second test?

Note: - The script is running as a Footrunner script.
On the client's machine the database is compiled (but the script isn't).
On my machine I've tried it both coupled and uncompiled - makes no
difference.

HELP

Pat

On 20 October 2016 at 20:04, Peter Bozek <peter.bo...@gmail.com> wrote:

> On Thu, Oct 20, 2016 at 6:17 PM, Pat Bensky <pben...@gmail.com> wrote:
>
> > 1: 123456789.99
> > 2: 123,456,789.99
> >
> > When the customer runs it on his Italian system, he gets:
> > 1: 12345678999
> > 2: <<<
> >
> > whereas he should get:
> > 1: 123456789,99
> > 2: 123.456.789,99
> >
> > ​What am I doing wrong?
> >
>
> Did he opens a method so it retokenizes? If yes, as his system decimal
> separator is comma, 123456789.99 is tokenized as 12345678999 - dot is not
> recognized as decimal separator.
>
> Other development environment assume dot is decimal separator whatever is
> system setting, 4D not.
>
> If you send your customer compiled structure, I do not have a clue.
>
>
> --
>
> Peter Bozek
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: European number format

[Peter Bozek]

On Thu, Oct 20, 2016 at 6:17 PM, Pat Bensky  wrote:

> 1: 123456789.99
> 2: 123,456,789.99
>
> When the customer runs it on his Italian system, he gets:
> 1: 12345678999
> 2: <<<
>
> whereas he should get:
> 1: 123456789,99
> 2: 123.456.789,99
>
> ​What am I doing wrong?
>

Did he opens a method so it retokenizes? If yes, as his system decimal
separator is comma, 123456789.99 is tokenized as 12345678999 - dot is not
recognized as decimal separator.

Other development environment assume dot is decimal separator whatever is
system setting, 4D not.

If you send your customer compiled structure, I do not have a clue.


-- 

Peter Bozek
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: European number format

[Pat Bensky]

OK, this option is checked ... are you saying I should un-check it?

Pat

On 20 October 2016 at 18:26, Spencer Hinsdale 
wrote:

> yes, it's on line eight, "use period and comma as placeholders in numeric
> formats"
>
> > On Oct 20, 2016, at 10:24 AM, Pat Bensky  wrote:
> >
> > Spencer - I can't find that setting Where is it? It isn't in
> > Database Settings->Compatibility.
> > Thanks
> > Pat
> >
> > On 20 October 2016 at 17:32, Spencer Hinsdale 
> > wrote:
> >
> >>
> >> I'm not following your test exactly, but maybe it needs the
> Compatibility
> >> setting that reads something like, "use both comma period as valid
> decimal
> >> separators"
> >>
> >>> On Oct 20, 2016, at 9:17 AM, Pat Bensky  wrote:
> >>>
> >>> ​What am I doing wrong?
> >>>
> >>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: European number format

[Spencer Hinsdale]

yes, it's on line eight, "use period and comma as placeholders in numeric 
formats"

> On Oct 20, 2016, at 10:24 AM, Pat Bensky  wrote:
> 
> Spencer - I can't find that setting Where is it? It isn't in
> Database Settings->Compatibility.
> Thanks
> Pat
> 
> On 20 October 2016 at 17:32, Spencer Hinsdale 
> wrote:
> 
>> 
>> I'm not following your test exactly, but maybe it needs the Compatibility
>> setting that reads something like, "use both comma period as valid decimal
>> separators"
>> 
>>> On Oct 20, 2016, at 9:17 AM, Pat Bensky  wrote:
>>> 
>>> ​What am I doing wrong?
>>> 
>> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: European number format

[Pat Bensky]

Spencer - I can't find that setting Where is it? It isn't in
Database Settings->Compatibility.
Thanks
Pat

On 20 October 2016 at 17:32, Spencer Hinsdale 
wrote:

>
> I'm not following your test exactly, but maybe it needs the Compatibility
> setting that reads something like, "use both comma period as valid decimal
> separators"
>
> > On Oct 20, 2016, at 9:17 AM, Pat Bensky  wrote:
> >
> > ​What am I doing wrong?
> >
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**