I have dataset that has BCD fields.
How can I change value of one BCD field using another fields. Something like Field3 := Field1 * Field2. One important not type of Field1 and Field3 is BCD, type of Field2 is Long.
I need SQL code that makes it. I have already tried to do it with following code but it doesn't work.
Update test Set Field3=Field1*Field2