Hi,

Does this is still supposed to work within Firebird 2.5 (superserver,
windows, 32 bits, database not backup/restored from 2.1 ODS, delphi
application using UIB components from current SVN trunk)

select count(*) from A_TABLE
where STRING_FIELD=? and BLOB_FIELD starting with ?

Here is the Delphi code :

with TUIBQuery.Create(nil) do
begin
Transaction := ATransaction;
SQL.Text := THE_SQL_ABOVE;
try
Prepare(True); // describe parameters
Params.AsString[0] := 'AString';
Params.AsString[1] := 'ASingleWord';
Open;
Result := Fields.AsInteger[0] > 0;
finally
Free;
end;
end;

It worked with Firebird 1.5 and Firebird 2.1, now with Firebird 2.5 it
raises this error : " Dynamic SQL Error SQL error code = -303
arithmetic exception, numeric overflow, or string truncation unknown
ISC error 335544914 Incompatible column/host variable data type Error
Code: 249."

What should I'm supposed to do ?

Regards,

--
Pierre Yager