Thanks Bonnie,
Interesting though. If you can define anything (decimal places) in the database environment, you should be able to retrieve it one way or another no?
If I remember correctly, "decimal places" is supported by standard SQL no?
It's probably me.
Thanks and kind regards,
Marc
PS : I totally agree that decimal places is not a storage but a formatting issue. Is it blasphematory then to want to define formatting at the DB level?
>Hi Marc,
>
>The DataColumn.DataType would indicate that it was a decimal datatype, but AFAIK, there is no specification for number of decimal places in a decimal datatype. That's pretty much a display thing, so there are various things you can do to specify how you want it formatted when you display it.
>
>
http://msdn.microsoft.com/en-us/library/system.decimal.aspx>
>~~Bonnie
>
>
>
>
>>In Access you can define a field "currency", give it a "Fxied" format and "Decimal Places".
>>
>>In DAO you would retrieve the "Decimal Places" as Properties("DecimalPlaces") of the ad hoc Field of the ad hoc TableDefinition.
>>
>>Anybody any idea where they would hide that in (vb).net (I would expect DataColumn, but I cannot find anything).
>>
>>Thanks and kind regards,
>>
>>Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.