>Hello All,
>
>i get asterisk displayed for negative numbers resulting from a calculated field in a view.
>
>This only happens when i browse the view object. (i.e clicking on browse)
>This does not happen when the Run the query from the menu or from the command window.
>
>This is affecting oother views which depend on it.
>
>Sample code:
>SUM(AdjQty.Adj_Qty) AS ADJ_Qty
>
>Any help please?
Can you show the exact code instead? I would guess, that the precision for the field is smaller than needed, e.g the field is, say, 4 digits, instead of 5 or 6.
You may also use a different field name for your sum and force number of digits with this trick (since CAST function doesn't exist in VFP6):
select sum(myField + 0000000.00) as MyNewField...
If it's not broken, fix it until it is.
My Blog