473,473 Members | 1,816 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Problem retrieving number of decimals on dbDecimal field type

5 New Member
Hi.

Im trying to use DAO 3.6 (in c#, net 2) to obtain the precision and scale of a field of type dbDecimal, but no success.

I found that the property CollatingOrder of the field objet has the precision of the field, but cant' figure how to obtain the scale.

Thanks

Alejandro
Mar 31 '07 #1
2 2296
MMcCarthy
14,534 Recognized Expert Moderator MVP
I'm afraid you have a problem in that a decimal is not a proper datatype but rather a subdatatype. As such the precision and scale properties are not available. Collating Order is not exactly precision although it will return the same value but I'm afraid I don't think there is any way to get the scale.

Mary
Apr 1 '07 #2
agasca
5 New Member
I'm afraid you have a problem in that a decimal is not a proper datatype but rather a subdatatype. As such the precision and scale properties are not available. Collating Order is not exactly precision although it will return the same value but I'm afraid I don't think there is any way to get the scale.

Mary
Oh... that's horrible...

well... there is a way access remembers the scale of the field...
meaby this is a dao bug? and/or jet bug? does any one knows a report exist in microsoft?

Thanks
Apr 2 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

16
by: Ling Lee | last post by:
Hello. I'm trying to write a small program that lets you put in a number as an integer and then it tells you the textuel representation of the number. Like if your input is 42, it will say...
3
by: Ciar?n | last post by:
I have a table with over a million rows and one of the fields contains amounts of money in text format. What is the most efficient way of converting this field to a number format that I can sum...
5
by: Jonathan Dodds | last post by:
I'm using ADO from an ASP 3.0 page written in JScript to query a database table in SQL Server 2000. One of the columns in a currency field. Instead of retrieving a value of 1095.60 like I expect,...
3
by: Frankie | last post by:
Hi, I am working on a form in which in a certain field a number of an employee can be entered. After entering this number I would like to show in the same form (real time) the name etc. of this...
7
by: Hiten | last post by:
Hi please check ffollowing conditon variable float1 and float2 holds user entered value..... Answer=float1 * float2; //output must be 8.5 output must to be 8.5 but it has 8.500002, i am...
36
by: beebelbrox | last post by:
Hi, I am new VB programming in Access and I am requesting help with the following code. WIndows OS MSaccess 2003 This code is attached to an unbound form that will display a specific recordset...
9
ADezii
by: ADezii | last post by:
One question which pops up frequently here at TheScripts is: 'How do I retrieve data from a Recordset once I've created it?' One very efficient, and not that often used approach, is the GetRows()...
1
by: javabeginner123 | last post by:
i have a java prob, and i have to solve it fast, but i'm just getting to know it, so plz help me solve it with full code completed, thanks so much. the prob is to create a monter fight and there is...
3
ADezii
by: ADezii | last post by:
Last Tip, we demonstrated the technique for retrieving data from a DAO Recordset, and placing it into a 2-dimensional Array using the GetRows() Method. This week, we will cover the same exact Method...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.