the_net_2.0
Banned
- Local time
- Today, 01:39
- Joined
- Sep 6, 2010
- Messages
- 812
all,
I have this situation and I can't figure out if it is actually relevant! I'm getting an overflow error in access on an INTEGER field at 33300, which is obviously over the allowable maximum for access's integer field size.
My question is: What is the difference between a signed an unsigned integer?
I just don't get this. I understand this much:
but so what?? Obviously a positive integer converts to a different binary number pattern than an unsigned (negative) number does, but again so what??
The issue I'm struggling with is that I have 5 processes that my numbers go through, and by the time it gets to stage 4, it is input into the field as 33300, but the field is (at that time) indicated as an integer, which of course throws the error.
The people we send this data to request that they have an unsigned integer in that field. However, I don't get the connection between their request and the signed. vs. unsigned part.
Apparently what happens in our code when it converts to the output format, is that the output number becomes -32236. I don't know the specifics behind this conversion, but I'm sure I could find out through google. But obviously, if our customer wants an unsigned integer (double field if it has to be 33300 to begin with) as the end result, that negative sign attached to the -32236 number has to be positive, as unsigned integers cannot be less than 0 in decimal format!
I'm absolutely confused by this. Can somebody shed some light for me on how simple this is please? The issues I'm facing are:
obviously I know how to do the first part, but the second is throwing me for a loop. Any help appreciated. I don't think I'll ever understand binary. Thanks guys!
Adam
I have this situation and I can't figure out if it is actually relevant! I'm getting an overflow error in access on an INTEGER field at 33300, which is obviously over the allowable maximum for access's integer field size.
My question is: What is the difference between a signed an unsigned integer?
I just don't get this. I understand this much:
- Signed Integers: Can have either a (-) preceeder or a (+) preceeder
but so what?? Obviously a positive integer converts to a different binary number pattern than an unsigned (negative) number does, but again so what??
The issue I'm struggling with is that I have 5 processes that my numbers go through, and by the time it gets to stage 4, it is input into the field as 33300, but the field is (at that time) indicated as an integer, which of course throws the error.
The people we send this data to request that they have an unsigned integer in that field. However, I don't get the connection between their request and the signed. vs. unsigned part.
Apparently what happens in our code when it converts to the output format, is that the output number becomes -32236. I don't know the specifics behind this conversion, but I'm sure I could find out through google. But obviously, if our customer wants an unsigned integer (double field if it has to be 33300 to begin with) as the end result, that negative sign attached to the -32236 number has to be positive, as unsigned integers cannot be less than 0 in decimal format!
I'm absolutely confused by this. Can somebody shed some light for me on how simple this is please? The issues I'm facing are:
- converting the int field to double, BEFORE the conversion takes place
- converting the negative output number to a signed integer
obviously I know how to do the first part, but the second is throwing me for a loop. Any help appreciated. I don't think I'll ever understand binary. Thanks guys!
Adam