Problem with FLOAT and field format "currency"

Classic Servoy
1

I type a number into a field connected to a MySQL 5.1 FLOAT dataprovider. The value is never updated but turns red and the form becomes unresponsive. This only happens when the field format is set to “currency”. What’s it all mean? :?

Servoy Developer
Version 3.5.3-build 516
Java version 1.5.0_13-121 (Mac OS X)

2

if you have just one format specified, that format is used for display and data entry. with a currency format, this means you need to input the currency symbol in addition to your numbers.

you can specify separate display and data entry formats by using the pipe symbol. a format of “$#,###,###.00|#” allows you to enter just numbers that will be displayed in currency.

also note that with mysql you do not want to use the float data type for storing currency as this is an approximate numeric storage type. use the exact numeric: decimal(19,2). if you create a number column with a length of 2 using servoy’s dataprovider you will get this number type. if you don’t specify a length, you will get the float number type. mysql backend specific tips only – not sure about all the numeric types in sybase.

3

HoD Log:
DATE: 12-28-07
ACCOUNT: “Person Not So Smart”
WHO: David
TIME: 25 mins
:wink:

Thx.

4

Doh!

HoD Log:
DATE: 12-28-07
ACCOUNT: “Person Not So Smart”
WHO: David
TIME: 25 mins

:wink:

5

Sorry for the double post, but I am getting forum errors.

6

Sorry for the double post, but I am getting forum errors.

Ran into problems sending Mail. Response: 550 See http://spf.pobox.com/why.html?sender=su … .171.70.66 (#5.7.1)

DEBUG MODE

Line : 164
File : smtp.php

7

After an upgrade earlier today there indeed appears to be a problem. One of our system administrators is investigating. Apologies for any inconvenience.

8

The good news is if you ignore the error you can still post. Some internal IP numbering changed this morning and is causing the mailserver to protest.

9

Our admin reports the problem has been addressed.

10

thertzler:
Doh!

HoD Log:
DATE: 12-28-07
ACCOUNT: “Person Not So Smart”
WHO: David
TIME: 25 mins

:wink:

The neighbors have come over to investigate why I am laughing so hard. Nicely done :)