Problem currency

Scriptcase 9 General
#1

i have application where there is a field in currency ,the application was working oke but after the last update
from version 9.6.000 to version 9.6.001 it don’t work anymore on INSERT the record I get error message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘6,00’’)’ at line 1

you can open the sql view it is this.

INSERT INTO test_currency (geld_bedrag) VALUES (’‘6,00’’)

the only thing a can see is when i open this in a normal tekst program is (’ ‘6,00’ ') instead of (“6,00”)

are there more pepole whit the same problem.

#2

Hello, just to tell you that in v9.6.001 i don’t have any trouble.
Here is screen copy of my app with a currency field (It is a double in the database ) :

image
image1212×834 38.2 KB

Here is the definition of the field (please note that i don’t use the regional parameter but I, manually, specified the space as the numbers delimiter, and the comma as decimal separator :

image
image1634×935 102 KB

I hope it could help you.

#3

Laurent
thancks for the answer.

The problem is found , it had to do with 2 things the character set was different with the database.
and in the connection under advanche settings you can set the decimal character.