Cindy,

I SET DECIMAL TO 0 in the LOAD() of my form. This is working. The problem is that the view's 1 numeric field is being created with decimal of 2. When browsing the view in the form's datasession, the decimals are hidden but why is this view's field created with a decimal of 2 in the view's structure? This can be seen with DISPLAY STRUCTURE.

However, from the command window, if I SET DECIMAL TO 0, USE myview, DISPLAY STRUCTURE, the view's field does Not have any decimals in the view's structure.

I'm not sure what the difference is.

Thanks,

Jerryt



>Jerry,
>
>From Help:
>
>"SET DECIMALS is scoped to the current data session."
>
>
>
>
>>Why does this view's field have no decimal in the command window, but 2 decimals in the form?
>>
>>I use DISPLAY STRUCTURE to see if the view's field has a decimal or not.
>>
>>The SET DECIMAL TO 0 hides the decimal but why is the view's structure different in the command window vs the form?
>>
>>Thanks,
>>
>>Jerryt