problem with strings and float

[morfasie]

hi all,

in my mysql DB my field is float 10,2.

i have normal query in crystal 10 pro, selecting all data. If I look at the field type in field exploer, it says the field is string[23], why is that? it should be number? because in the Db it is a number?

So I can't sum that field or do any algorithmic stuff on it?

thanks

 

[synapsevampire]

What happens if you create a formula of val({table.field}) against it?

-k