[Issue 127109] New: External database connection returns no data (ODBC)

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127109

          Issue ID: 127109
        Issue Type: DEFECT
           Summary: External database connection returns no data (ODBC)
           Product: Calc
           Version: 4.1.2
          Hardware: Mac
                OS: Mac OS X 10.11
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: jlbrown@bordo.com.au

Created attachment 85670
  --> https://bz.apache.org/ooo/attachment.cgi?id=85670&action=edit
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' )

-- 
You are receiving this mail because:
You are the assignee for the issue.