Error

Classic Servoy
1

I am getting the following error:

java.lang.ArrayIndexOutOfBoundsException null

this occurs when I add a decimal point during the folowing scenario:

I have the following fields:

Line Item Table =
Total_Cost (cost * qty) (Stored Calc)
Line_Item_Sum (Sum of Total_Cost) (Aggregation)

Orders Table =
return orders_to_orderlineitems_byorderid.Line_Item_Sum; (Stored Calc)

Every thing works fine with whole numbers, If I change the cost from 1000.00 to 1000.13 I get the above error. Any Ideas?

Thanks Erich

Servoy Developer
Version R2 2.2.1rc3-build 332
Java version 1.4.2_04-b05 (Windows XP)
SQL2000 Backend

2

This is still happening, it is intermitent I have enclosed a screen shot. I can change the cost to .12 and it works fine, then change it back to .00 then back to .12 and I get the error.

Any Ideas, could it be a data type issue on the backend. I have noticed that allot of the number field created via servoy, end up as float data types in SQL. I then change them to money data types.

Is it a better practice to create the fields on the backend first?

3

I did notice that If insert decimal values via a method I do not get the error, only if I manually change the value in the field