Argh!
Connection>>delimitedIdentifierCharacter should be
ODBCConnection>>delimitedIdentifierCharacter
Terry
===========================================================
Terry Raymond
Crafted Smalltalk
80 Lazywood Ln.
Tiverton, RI 02878
(401) 624-4517
[hidden email]
<
http://www.craftedsmalltalk.com>
===========================================================
_____________________________________________
From: Terry Raymond [mailto:
[hidden email]]
Sent: Thursday, April 01, 2010 11:39 AM
To: VWNC (
[hidden email])
Subject: 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
Locked
