Gabriel,

<< edatabase error with message query0: field 'T09_BAIXA' is of unknown
type. >>

See my response - you need to make sure that you set the parameter data type
first when using Clear.

--
Tim Young
Elevate Software
www.elevatesoft.com

very good.

thank you very much.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escreveu na
mensagem news:9269EB92-15D2-4E66-A2D2-68EF30E397DE@news.elevatesoft.com...
> Gabriel,
>
> Use the TDBISAMParam.Clear method:
>
>    if T09_Baixa.Text <> '  /  /    ' then
>      DM.Query0.ParamByName('T09_Baixa').AsDate := T09_Baixa.Date
>    else
>      begin
>      DM.Query0.ParamByName('T09_Baixa').DataType:=ftDate;  // Be sure to
> set the data type of the parameter
>      DM.Query0.ParamByName('T09_Baixa').Clear;
>      end;
>    DM.Query0.ExecSQL;
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>