Rob,

This makes perfect sense and it is an easy fix.

Thanks,
Jason


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Wednesday, October 16, 2013 9:59 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] IBO 5.3.1 Build 1862 has been released.

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
>



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
Groups Links




[Non-text portions of this message have been removed]