Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

2020202.020202 - Initialization Value?

2020202.020202 - Initialization Value?

2020202.020202 - Initialization Value?

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?

RE: 2020202.020202 - Initialization Value?

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.  

Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close