Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement