I am starting to use Standard Cost Distribution for more detailed information concerning our shop floor order variances. However, I see a $.02 Labor Rate Variance distribution when there should be none. When I access the Macola database using MS Access, I see a value in the "Dist_Hrs" and "Lbr_Rate" fields of 2020202.020202 which I believe might be leading to this erroneous $.02 distribution. Can somebody please help me understand why this 2020202.020202 value is there and what I can do to correct this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
2020202.020202 - Initialization Value?
- Thread starter hardrockq
- Start date
This would probably better be asked in a Macola forum as Pervasive.SQL (used by Macola) is only the database engine and only stores what it is told to store by the application.
That being said, a field with 2020202.020202 almost looks like a hex numeric repesentatation of a string field (hex 20 being the string equivalent of a space). My best guess is that somehow a string value of all spaces was inadvertantly inserted into this field and ODBC is trying to interpret it.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
That being said, a field with 2020202.020202 almost looks like a hex numeric repesentatation of a string field (hex 20 being the string equivalent of a space). My best guess is that somehow a string value of all spaces was inadvertantly inserted into this field and ODBC is trying to interpret it.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
- Status