hank you for this report. I will check it out ASAP and if confirmed will issue a fix to SVN.

Regards

Tony Whyman

MWA

> There is a bug in IBX 2.4.0 components. This version of IBX works with Firebird-4.0.0.1963-0-Beta2, but does not work with Firebird-4.0.0.2496-1. When calling the Prepare method for an SQL query, an error is thrown: Data type unknown When Executing: (here is the query text).
> The fix for this error is quite simple:
> 1. Open the downloaded package fbintf [Packages -> Open the downloaded package -> (Select fbintf)];
> 2. Select the FB30Statement.pas file and load it;
> 3. Find the procedure TIBXINPUTSQLDA.Bind;
> 4. We make the changes suggested by Vlad Khorsun:
>
>     procedure TIBXINPUTSQLDA.Bind (aMetaData: Firebird.IMessageMetadata);
>     var i: integer;
>     begin
>       FMetaData: = aMetaData;
>       with FFirebird30ClientAPI do
>       begin
>     // Count: = metadata.getCount (StatusIntf);
>         Count: = aMetaData.getCount (StatusIntf);
>
> 5. Correct the procedure in the same way: procedure TIBXOUTPUTSQLDA.Bind (aMetaData: Firebird.IMessageMetadata);
> 6. Compile
>
> Big request for these fixes in IBX 2.4.0
>
> With respect.

Many thanks for the report - and for finding the bug.
I am snowed under at the moment with the day job,
but managed to find time today to check out the fix and
run the test suite on the updated version. All looks good.
The update is now available in SVN and if no other bugs
are reported will try and find time over the weekend to
prepare and release updates zips. I have also posted
updates to the Lazarus forum.

Regards

Tony Whyman

MWA