Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: How to Null a Date Field

    I'm writing some code in VB that uses ADO through the ODBC driver for Timberline/Pervasive and I'm trying to figure out how to null a date field. I've tried various values such as an empty string, Null, even the zero value for a COleDateTime object (which is "12/30/1899 12:00:00 AM"); none of which work. They all result in either "Invalid field format" or "Type mismatch" errors.

    How do you set a date field to Null in Pervasive?

    Joe A.

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    Null should work. YOu might try the Insert statement outside of the VB app. Use the COntrol Center. If it works there, it'll work in the VB app. You might also verify that the field really is a Date.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts