I am working on some queries in Pervasive and the language isn't quite what I am used to. I'm used to MS SQL 2000. I'm having problems with the comparison operator side of the query. For example:
SELECT * FROM "JCJHST01" where shipped = ""
Some of the items in the shipped field are null. I can take care of that just fine with "is null". My above example is how I would evaluate the shipped field in MS SQL when there is an empty character set. I get errors when I try to do so in Pervasive.
The error is: ODBC Error: SQLSTATE = 22008, Native error code = 0
Invalid date, time or timestamp value.