SQLite - ODBC - Concatenation
(1) By anonymous on 2020-08-24 14:23:05 updated by 1.1 [link] [source]
I am using the 32-bit ODBC driver from http://www.ch-werner.de/sqliteodbc/ with ADODB. sqlite> select 'sun' || 'flower' as flower; flower --------- sunflower When I use the concatenation operator || with an ODBC connection, it fails. How do I concatenate strings when executing an SQL statement with an ODBC connection? PS: I've tried + and & instead of || and I still have the failure.
SQLite - ODBC - Concatenation
(1.1) Originally by anonymous with edits by Richard Hipp (drh) on 2020-08-24 14:54:51 from 1.0 updated by 1.2 [link] [source]
I am using the 32-bit ODBC driver from http://www.ch-werner.de/sqliteodbc/ with ADODB. ~~~~ sqlite> select 'sun' || 'flower' as flower; flower --------- sunflower ~~~~ When I use the concatenation operator `||` with an ODBC connection, it fails. How do I concatenate strings when executing an SQL statement with an ODBC connection? PS: I've tried + and & instead of `||` and I still have the failure.
SQLite - ODBC - Concatenation
(1.2) Originally by anonymous with edits by Richard Hipp (drh) on 2020-08-24 14:59:56 from 1.1 [source]
Original by "anonymous". Revised for formatting by "drh"
I am using the 32-bit ODBC driver from http://www.ch-werner.de/sqliteodbc/ with ADODB.
sqlite> select 'sun' || 'flower' as flower;
flower
---------
sunflower
When I use the concatenation operator ||
with an ODBC connection, it fails.
How do I concatenate strings when executing an SQL statement with an ODBC connection?
PS: I've tried + and & instead of ||
and I still have the failure.
(2) By Clemens Ladisch (cladisch) on 2020-08-25 07:13:49 in reply to 1.2 [link] [source]
Works for me.
It might be useful to be more specific than "it fails".
(3) By anonymous on 2020-08-25 08:26:58 in reply to 2 [link] [source]
Thanks for confirming that it works.
The error I am getting is: syntax error near "'flower'
I re-tried my code in Excel VBA where it works.
I investigated further and the problem is with APL not being able to transmit the concatenation operator correctly to ADODB.
I do not see a 'wish-list' in this forum; I wonder if a future SQLite release might offer the CONCAT function.