Decimals

Well I have a problem with the decimal numbers. I have a field in mysql called aaa and it have to be decimal (6,2). If I enter the information direct form mysql I put for example 10.25 and it accept ok.

In my form I make the field aaa as VALUE and put 2 decimals and the “,” as decimal.

And In Scriptcase configuration I put the decimal as “.

But when I excecute the form if the database have a decimal number the form show it, but if I whant to insert/update 10.25 or 10,25 the form accept the number I enter but it don`t pass to the mysql, the mysql show me only 10.00 why??? How I could make to accept decimals???.I Have Scriptcase 4

Thanks.
Matias.

Re: Decimals

Enable the Debug Mode and see how the values are be inserted.

V?tor Jamil

Re: Decimals

Hi Matias,

You have solved the problem with decimals?, the same thing happens to me but I don’t find the problem.

Thanks in advance

Re: Decimals

may be you can find the solution as described as at this problem

http://www.scriptcase.net/forum_en_us/index.php?topic=1101.msg3100#msg3100

Re: Decimals

Hi EricB,

Really the problem was the connection to the database.

Thank you very much