U++ forum: Welcome to the forum

Re: SQLITE3: Bind parameter by name [message #26666 is a reply to message #26654]

Tue, 18 May 2010 17:27

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

luzr wrote on Tue, 18 May 2010 10:26

Well, I see the point.

Anyway, for constructing SQL, we have designed SqlExp Smile

BTW, cannot you just pass parameters to the function where you construct the SQL? In the past 10 years, that worked quite well for me (using SqlExp) Smile

Quote:

Parameters support SQLITE, PostgreSQL, Oracle. Not sure about MySQL.

MySQL does not support it.

http://dev.mysql.com/doc/refman/5.0/en/mysql-stmt-prepare.ht ml

I also believe that PGSQL does not support it too.

BTW, with litte effort, you can add this feature "externally", using only parameter positions.

All you need to do is parse the SQL command, replace your named parameter placeholders with "?" and create the Index of names in the process, then simply translate parameter name to position... Much simpler than patching all SQL clients...

Mirek

Thank you Mirek for hint!

Report message to a moderator