Hi

Have built a we test app and actually found where the problem is in
IBO! The issue is in IB_Components.pas the procedure
TIB_SchemaCache.ExtractParamName( ....) from around line 14984. The code
essentially assumes the parameters specified as :old are special and
will always have a '.fieldname' afterwards. in my case this isn't
true. This isn't an SQL reserved word issue as you have always been
able to use SQL reserved words as parameter names (for example, in the
code below :Select works just fine as a parameter name).

Here's my test code..


*DB*
Create table a (
Ref BigInt,
Old Char(1)
)


*Code*
IBOQuery.SQL.Clear;
IBOQuery.SQL.Add('SELECT * FROM a WHERE Old = :Old');
Query.Prepare; /* Breaks here */


I believe it should be an easy fix. I'm off home soon but am happy to
let you remote in and see tomorrow if required.

Cheers
Rob

On 17/10/2013 3:43 p.m., IBO Support List wrote:
> Possibly, but it could also be a need to use double quotes as well.
> Perhaps you can send me a little sample app or I can just jump in and have a
> look.
>
> Jason
>