Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Desperately looking for MS Access [decimal places]
Message
 
À
05/01/2011 20:08:20
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
01494823
Message ID:
01494919
Vues:
56
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform