Created attachment 85670 [details]
Query with no data returned

Have an ODBC connection to a 4D database. Connection works fine in that it can see all the tables.


But the query returns no data.

The SQL is:

SELECT `HInvoice_Lines`.`Transaction_LK` AS `Transaction_LK`, `HInvoice_Lines`.`Inventory_LK` AS `Inventory_LK`, `HInvoice_Lines`.`Amount` AS `Amount`, `HInvoice_Lines`.`Multi` AS `Multi`, `HInvoice_Lines`.`Client_LK` AS `Client_LK`, `HInvoice_Lines`.`Type` AS `Type`, `HInvoice_Lines`.`Period` AS `Period`, `HInvoice_Lines`.`Client_Class` AS `Client_Class`, `HInvoice_Lines`.`IN_Class` AS `IN_Class`, `HInvoice_Lines`.`Rep_ID` AS `Rep_ID`, `HInvoice_Lines`.`Client_Area` AS `Client_Area` FROM `HInvoice_Lines` `HInvoice_Lines` WHERE ( `HInvoice_Lines`.`Period` > 24 AND `HInvoice_Lines`.`Period` < 100 AND `HInvoice_Lines`.`Rep_ID` = 'ISB' )

But even simple query like this does not return anything:

SELECT `Clients`.`ID` AS `ID`, `Clients`.`State` AS `State` FROM `Clients` `Clients` WHERE ( `Clients`.`ID` = 'APF' )