decimal point problem

Classic Servoy
1

Hi ya,

Can’t work this one out Ive created a table in Aqua Data Studio and 2 of the fields contains a datatype smallmoney NULL I have tried :

decimal NULL
decimal(3,2) NULL
decimal(11,2) NULL
float

And probably a few other values just to be able to store a money value number such as 33.26 its impossible so far I keep getting java.lang.ArrayIndexOutOfBoundsException null I can enter 30 or even 30.5 but dare I add another penny NO!

Ive spent hours on this and getting no where fast any one had this problem or can see the obvious here?

Thanks

:wink:

2

This error does not appear to be a database error but rather a Java error.
To confirm this, I would imagine you could issue an insert statement into the table from SQL Anywhere’s Interactive SQL.

Lets assume that your table is named foo. The following command will insert the value 11.22 into the table foo(this assumes that you do not have constraints on the table and your smallmoney column is named mySmallMoney)

insert into foo (mySmallMoneycol) values (11.22);

If this works, you know it is not the database but rather the tool you are using as it is parsing the decimal.

Have you tried treating the value as a string to see if this makes a difference?

3

Hi Chris,

I think I’ve found the problem. It seems it’s to do more with the driver I was using.

I’ve changed my driver to jtds-1.1 and so far so good

Thanks
:smiley: