Subject Problem with field alias in 4.9.13 Beta 25
Author Thomas Steinmaurer
Hello Jason,

after upgrading to 4.9.13 Beta 25, it seems there is something messed up
when accessing a field in a result set by field alias name.

With a TIB_Cursor. The following SQL statement:

select
count(rdb$trigger_name) as anzahl
from
rdb$triggers
where
rdb$trigger_name=:trigger_name
and rdb$relation_name=:relation_name


Using the cursor like that:


c1.Close;
c1.ParamByName('trigger_name').AsString := ATriggerName;
c1.ParamByName('relation_name').AsString := ATableName;
c1.First;
Result := c1.FieldByName('anzahl').AsInteger > 0; <= exception here



Worked fine with e.g. 4.9.8.


Please comment. Thanks.




--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!