Jerry,
Where did you open your view first? In DataEnvironment? You have to set set decimals to 0 in BeforeOpenTables of DE.
HTH
>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
If it's not broken, fix it until it is.
My Blog