04.03.2010 17:41, Danny García Hernández wrote:

> 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?.

You should find out why FSQLParams.AsXSQLDA contain XSQLVAR with
sqltype not compatible with type of parameter from FB point of view.
--
SY, SD.