Subject | Rewriting components from FreeIB |
---|---|
Author | Danny García Hernández |
Post date | 2010-03-04T16:41:55Z |
Hi, we are rewriting our data access components to make it compatible
with Delphi 2009 Unicode implementation, this components inherite from
the old FreeIB. In this moment all components are installed and the
aplication compile fine, the problems begin when a try open a query
passing Strings like params, for example, this select:
var q: TFIBQuery;
begin
q.SQL := 'select * from account where family <> ?family';
q.Params.ByName['FAMILY'].AsString := 'FAM';
q.Open;
end
Inside FIBQuery the ExecQuery function call this:
Call(isc_dsql_execute2(StatusVector,
TRHandle,
@FHandle,
1,
FSQLParams.AsXSQLDA,
nil), True);
And this call return a -303 error code "Incompatible column/host
variable data type". Can someone explain what is happening or advice
where to find posible problems?.
Regards
Danny
with Delphi 2009 Unicode implementation, this components inherite from
the old FreeIB. In this moment all components are installed and the
aplication compile fine, the problems begin when a try open a query
passing Strings like params, for example, this select:
var q: TFIBQuery;
begin
q.SQL := 'select * from account where family <> ?family';
q.Params.ByName['FAMILY'].AsString := 'FAM';
q.Open;
end
Inside FIBQuery the ExecQuery function call this:
Call(isc_dsql_execute2(StatusVector,
TRHandle,
@FHandle,
1,
FSQLParams.AsXSQLDA,
nil), True);
And this call return a -303 error code "Incompatible column/host
variable data type". Can someone explain what is happening or advice
where to find posible problems?.
Regards
Danny