Yet another OleDBDataAdapter quirk, the EMPTY(FIELDNAME) condition
Posted on 2006-06-21
Take a simple select.
SELECT ID, LAST, FIRST, ORDER
WHERE ORDER IS NULL
This will not work in the table I am pulling from because the field is not actually NULL it is blank. For some reason blank and NULL are not the same, maybe tonight after a few glasses of Jack Daniels that will make sense to me. So according to my friend Google the usage of EMPTY(ORDER) should work and behold in the Query Builder is does run !! The problem is when you hit ok it says the select statement cannot be generated. I manually do the select statement in the code, and it still does not run. Am I missing something ?