Not familiar with IBX, but maybe a Prepare
between Close and ParamByName helps

----- Original Message -----
From: "Sergio H. Gonzalez" <shg_sistemas@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, August 14, 2008 2:37 PM
Subject: [firebird-support] Incorrect values within SQLDA structure


> Hello, I use Delphi6 / IBX and with the query component I'm attaching
> bellow,
> I'm getting this error:
>
> "Incorrect values within SQLDA structure"
>
> I open the table like this:
>
> with qConceptos do
> begin
> Close;
> [...]
> ParamByName('PAGO_COBRO').AsString := 'T';
> ParamByName('SIGNO').AsString := 'T';
> Open;
> end;
>
> I'm using FB2.1.1. Before updating (with FB1.5) the query worked well. Any
> idea?
>
> Thanks !!!
>
> Sergio
>
> ---------------------------------
>
> object qConceptos: TIBQuery
> Database = DM.IBdb
> Transaction = DM.IBtr
> AfterScroll = qConceptosAfterScroll
> SQL.Strings = (
> 'select'
> ' DESCRIPCION, '
> ' ID_CONCEPTO, '
> ' PAGO_COBRO, '
> ' SIGNO '
> 'from '
> ' CONCEPTOS_BANCOS'
> 'where'
> ' ((PAGO_COBRO = :PAGO_COBRO) or ( :PAGO_COBRO = ''T'' ))'
> ' and '
> ' ((SIGNO = :SIGNO) or (:SIGNO = ''T'' ))')
> Left = 624
> Top = 328
> ParamData = <
> item
> DataType = ftUnknown
> Name = 'PAGO_COBRO'
> ParamType = ptUnknown
> end
> item
> DataType = ftUnknown
> Name = 'PAGO_COBRO'
> ParamType = ptUnknown
> end
> item
> DataType = ftUnknown
> Name = 'SIGNO'
> ParamType = ptUnknown
> end
> item
> DataType = ftUnknown
> Name = 'SIGNO'
> ParamType = ptUnknown
> end>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>