Issue 127109

Summary: External database connection returns no data (ODBC)
Product: Calc Reporter: jlbrown
Component: open-importAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest)    
Version: 4.1.2   
Target Milestone: ---   
Hardware: Mac   
OS: OS X 10.11   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Query with no data returned none

Description jlbrown 2016-09-13 07:07:34 UTC
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' )