Subject RE: RE: [firebird-support] Re: Possible to write this in a way that indices will be used
Author Maya Opperman
>Set Wrote:
>Did you try combining specifying a plan and converting to a range?
Though you still cannot change
>the plan depending on input params.
That's the problem ;-)

>With EXECUTE STATEMENT I suppose you could try to double any quotes
that you find,
>so that the statement at least could work.
Hmm.., I've tested it now, and I see it's just single quotes that's the
problem - I assumed %, ", :, etc would have been problematic too, but
I'm using '=' not 'like', so the other's shouldn't be an issue here.
Great.