Fida,

Do the *'s happen with all of your data or only one particular record?

Have you stepped through this part of the program in the debugger and seen exactly what is in each of these variables at the time?

Put sell_price*(bookvalue/total_bookvalue) in the debugger's watch window and step through some of the records in your table, including any kown bad ones.

What do you have SET DECIMALS and SET FIXED set to? Please remember that these are scoped to the datasession.



>Jim,
>
>Thanks for the reply. But this is not the case.
>I have say for example 1 main asset and four sub assets.
>
>The total purchase price for all these is say R 100.12 (R) is south african currency. The total bookvalue is say R 54.78
>Now i sell the main asset and the total selling price is say R78.00.
>What I do is divide the R78.00 into the 4 assets like this :
>
>I say totsell = sell_price*(bookvalue/total_bookvalue)
>bookvalue in the above formula is per the individual asset
>
>so this would read e.g totalsell= 78*(12.45/54.78)
>
>Do u find the error in this??
>
>Thanks
>Fida
>
>
>>Fida,
>>
>>The 8's represent a numeric overflow, that is the number is too large to display in the space provided. Thsi can be one of two problems in your situation, either the number is too large for the field in the table and this emans your data is forever gone, or the number is too large for the way you are displaying it. The second one is easy to fix, give the display more room.