U++ forum: Welcome to the forum

Re: SQLITE3: Bind parameter by name [message #26631 is a reply to message #26575]

Mon, 17 May 2010 14:48

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

tojocky wrote on Wed, 12 May 2010 09:55

Hello all,

How about to implement in SQLITE bind parameter by name? not only by index.

example of sqlite text:
"SELECT * from sqlite_master where type=table and name =:table_name"

in SQL class need to add meber:
Sql::SetParamName(String p_name, int p_index);
or add direct:
Sql::SetParam(int i, const Value& val, String p_name)
or
Sql::SetParam(String p_name, const Value& val) // auto increment parameter index
by using:
const char *sqlite3_bind_parameter_name(sqlite3_stmt*, int);

Can I add this functionality and propose for adding in library?

Any opinion are welcome!

Best regards, Ion Lupascu (tojocky)

As SqlExp seems to be dominant choice for doing SQL, I see little benefit here. Also, not every DB engine supports this and you would require a common interface.

I am strongly opposed to this.

Mirek

Report message to a moderator