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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

invalid precision value

Status
Not open for further replies.
LucasH

LucasH

IS-IT--Management
Oct 28, 2003
93
0
0
US
Hi,

I am using MS Access ODBC to interface with a Pervasive SQL 9.1 db. I normally have no problems whatsoever, but at a particual client site, I cannot edit (or append) any date records. As soon as I enter a date (or try to add a record with dates in it) I get an Invalid Precision Value (#0) error. It seems this has just started happening.

Anyone have any ideas around this problem? I have tried the db with Access 2003, 2007 with the same results.
 
Sort by date Sort by votes
Is the error only occurring at one site? If so, what's different about that one site? What is the exact version of PSQL being used (v9.1x.xxx.xxx)? Have you considered updating to v9.52 (SP2 plus Update)?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

profoundhypnotic
  • Locked
  • Question
how to select min and max value and the date for each
Replies
1
Views
142
mirtheil
mirtheil
michellepace
  • Locked
  • Question
Basic SQL: Add column to select statement (ie value from another table)
Replies
1
Views
130
michellepace
michellepace
David Ford
  • Locked
  • Question
[pervasive][odbc client interface] Numeric value out of range. (#0) - MS Access and Sage 50
Replies
2
Views
97
David Ford
David Ford
JRCharlie
  • Locked
  • Question
InValid Column Name 1
Replies
10
Views
103
JRCharlie
JRCharlie
nitara
  • Locked
  • Question
adding zero before the value
Replies
1
Views
52
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top