Mike,
Does it work with a test against {/:} ?
I have come across this in the way distant past and now always check datetime
fields against a manufactured DateTime as opposed to Empty()
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.
