Is this wrong?

On Mar 1, 2018, at 09:25, Doug Easterbrook <doug@artsman.com> wrote:

> just an opinion. I’ve found bind variables limiting more often than not.

That’s interesting. I can’t say we’ve ever encountered a situation where I’d call a bind variable “limiting”.

For PostgreSQL, I expect the DAM uses the PQexecParams function, which separates statement data from parameters. Per the PostgreSQL docs (www.postgresql.org/docs/8.4/static/libpq-exec.html#LIBPQ-EXEC-MAIN <www.postgresql.org/docs/8.4/static/libpq-exec.html#LIBPQ-EXEC-MAIN>):

> The primary advantage of PQexecParams over PQexec is that parameter values can be separated from the command string, thus avoiding the need for tedious and error-prone quoting and escaping.

Splitting user data from the statement just makes design sense, IMHO. Perhaps our bind variable implementation solves issues you’ve encountered, or, more likely, we run different styles of SQL commands and haven’t hit similar walls.

Alex

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com