Hello, everyone,
I have a problem with MySQL, using a SPT. Maybe one could help me here?
SELECT MAX(tData) AS tField FROM table1
WHERE uId LIKE 'parameter'
I use this SPT to download the records from both MySQL and MSSQL Server. The problem appears when in the backend table are no matching records.
MSSQL Server returns a cursor with 0 records, MySQL returns a cursor with 1 record, containing { / / : : }.
ISNULL(tField) return .F., EMPTY(tField) returns .F.!!! That thingie is not empty, is not null, is not equal with itself! What the heck?
The same SQL Command, executed in native MySQL environment, returns NULL. So, I suspect that is a ODBC problem.
Anyone knows why this is happening and what to do to avoid it?
Many thanks.
Grigore Dolghin
Class Software.