Home » U++ Library support » U++ SQL » SQLITE3: Bind parameter by name
Re: SQLITE3: Bind parameter by name [message #26722 is a reply to message #26718] |
Fri, 21 May 2010 12:31   |
|
frankdeprins wrote on Fri, 21 May 2010 10:06 | Hello,
I have a question related to this as well.
I am creating a database tool for sqlite where the user can launch arbitrary statements and, before executing them, I have to check whether there are bind variables (and how many).
As you say, the interface of the Sql class is quite general and this seems to be lacking.
I tried the ParseForArgs function by copying it in my sources, but it is not really fool proof, as it does not take comments in the statement in account.
e.g. the function returns 1 for this statement:
select
field -- just some field or not?
from
table
although the '?' in this case is not really a bind variable.
Any suggestions?
frank
|
To be sure, remove comments form sql statement!
|
|
|
Goto Forum:
Current Time: Fri Jul 04 23:05:19 CEST 2025
Total time taken to generate the page: 0.03751 seconds
|