Subject | RE: RE: [firebird-support] Re: Possible to write this in a way that indices will be used |
---|---|
Author | Maya Opperman |
Post date | 2008-05-19T08:43:23Z |
>Set Wrote:Though you still cannot change
>Did you try combining specifying a plan and converting to a range?
>the plan depending on input params.That's the problem ;-)
>With EXECUTE STATEMENT I suppose you could try to double any quotesthat 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.