Forum Discussion

QIAO's avatar
QIAO
Helper II
8 years ago
Solved

We cannot convert the value null to type table

I try to use Direct Query mode to load data, but always get "we cannot convert the value null to type table" in the "Create connections" stage.

Found not error in ODBC trace log.

WHY??

 

I can run Import mode smoothly.

 

Need Help
  • QIAO's avatar
    QIAO
    8 years ago

    Solved, it's because SQLExecute should return SQL_SUCCESS instead of return SQL_NO_DATA when load empty table.

     

5 Replies

    • QIAO's avatar
      QIAO
      Helper II
      8 years ago

      I tested. When i comes to use Query Editor, it runs okay.  But get data through Home->Get data, it would throw error like this.

      • QIAO's avatar
        QIAO
        Helper II
        8 years ago

        Solved, it's because SQLExecute should return SQL_SUCCESS instead of return SQL_NO_DATA when load empty table.