ODBC queries don't recognize backquote as a quote character

ODBC queries that use the backquote as a quote character are not parsed
correctly. The following select will work fine;

select `col1`,`col2` from `myTable`

But

select `col1?`,`col2` from `myTable`

Will not work because the ? is detected by ExternalDatabaseSession>>setupQuery:
and will require an input binding.

The quote character should not be a fixed character but it should be the
value returned by Connection>>delimitedIdentifierCharacter.

Our software uses this value as the quote character and it seems the backquote
is the return value when connecting to an Excel spreadsheet via ODBC.

Terry
 
===========================================================
Terry Raymond
Crafted Smalltalk
80 Lazywood Ln.
Tiverton, RI  02878
(401) 624-4517      [hidden email]
<http://www.craftedsmalltalk.com>
===========================================================


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc