[16-04-2005 1:16, James Berry escreveu]
I'm not the OP, but I'm simply suggesting that it would be, in general,
really nice if the architecture could allow bound parameters for many
more of these cases. Not to the point of keyword substitution (that
would change meaning of a statement) but for any parameter.
Yes, snprintf and friends can be used, but the ability to use bound
parameters can really clean up code, and help also to separate SQL
snippets from logic code.
It's not a must have, but a nice nicety.
I'm playing as the devil's lawyer here (this is right in English?), but
you must remember bindable parameters are for pre-compiled statements so
a lot of restrictions are in order here.
By making the bindable parameter more flexible you will be slowing the
performance of the execution, as it will have to make extra preparation
before binding the values.
(Hope I had it right, as I'm no sqlite expert)
Regards,
~Nuno Lucas
