Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.1.21, 3.2.5
-
None
Description
The table can be linked, but the rows will be showed as "#Deleted".
There are 2 things in here - why it does not work in normal mode, and while it does not work with NOBIGINT option that supposed to make the column to look like normal int column. The latter is easier - SQLColumns returns SQL_BIGINT data type for such column, and if change this to SQL_INTEGER NOBIGINT fixes the issue.
The former is more complicated and appears to be resembling ODBC-360. Access reads bigint values as SQL_WCHAR. Not sure why atm but I guess if we make it use different type this will solve the issue.
Attachments
Issue Links
- relates to
-
ODBC-360 Unable to get data from tables with VarChar or Char as primary keys
-
- Stalled
-