SQLite - ODBC - Concatenation
(1.2) Originally by anonymous with edits by Richard Hipp (drh) on 2020-08-24 14:59:56 from 1.1 [link]
*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
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]
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.