Table names in a SELECT including a hypen will modifed by adding spaces

[GStegemann]

Hi Edwig,

a table name with an hyphen and/or period used in an SELECT statement will be modified by the ODBCQueryTool.

Example:

SELECT lotId,state,qty,p,rk,sortReal,queueTime,location FROM "DispatchList_64-GU.txt" WHERE lotId LIKE '18%.%';

throws the following error:

SELECT lotId , state , qty ,p, rk , sortReal , queueTime , location FROM "DispatchList_64 - GU .txt"..... : Error in SQL statement: ODBC-call returned [-1] : [42S02][-1305][Microsoft][ODBC Text Driver] Das Microsoft Jet-Datenbankmodul konnte das Objekt 'DispatchList_64 - GU .txt' nicht finden. Stellen Sie sicher, dass das Objekt existiert und dass die Namens- und Pfadangaben richtig eingegeben wurden.

The file, i.e. the table, does exist. Therefore I assume that the modified table name causes this error. I think a quoted table name should not be modified by the ODBCQueryTool. See also attached screenshot.

ODBCQuery from Jaime de los Hoyos M. accepts such table names.

Best regards,
Gerhard