A few questions:
- What's the exact error?
- What's the definition of the Stored Procedure?
- Where does it fail (in the Pervasive Control Center or your application or both)?
- What's the actual command to call the procedure that you're using?
- Make sure the date is formatted properly (YYYY-MM-DD). It also needs to be enclosed in single quotes ('2005-03-07').
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.