frankdeprins Messages: 99 Registered: September 2008 Location: Antwerp - Belgium
Member
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.