Mike, My "incident" was with Postgress and also MySQL but the MySQL was fixed by subsequent revisions so I think it may well be something to do with the MariaDB Drivers. One would have thought that correct drivers would have been taken over in the fork from MySQL.
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of [email protected] Sent: 03 August 2015 07:23 To: [email protected] Subject: X-files: how are these 2 values not the same?!?!??? VFP9SP2 with MariaDB (MySQL) backend Check out this simple 3-variable screenshot: http://mbsoftwaresolutions.com/images/xfiles.png tCheckin is in a VFP cursor and is empty. xx was defined as follows: xx = {/:} The reason I'm baffled is because my code to test for EMPTY(tCheckin) doesn't find this record in the cursor. It says it's NOT empty. HUH?!?!? The workaround is to check for DAY(tCheckIn) = 0. BIZARRE!!!! Hence the reference to the X-Files TV show of yesteryear. --Mike [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
