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 [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 [link] [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.