Hi Kadee,
Let stop talking nonsense.
Simple advice:
use Tiboquery.Prepare before you assign params[0]
or
just use ParamByName('dept_no') instead of params[0]


Best regards
Ramil R. Khabibullin

> Hi all;
>
> I use IBO_4_ld on D5 ent.
>
> I got a problem about parameter of Tiboquery.
>
> this is the situation:
>
> Tibodatabase -> Tibotransation ->Tiboquery
>
> Tibodatabase.databasename := \examples\employee.gdb
>
> Tiboquery.sql:
> select * from employee
> where dept_no = :dept_no
>
> bitbtn1.onclick:
>
> Tiboquery.close;
> Tiboquery.params[0].value := '623';
> Tiboquery.open;
>
> bitbtn2.onclick:
> Tibodatabase.close;
> Tibodatabase.open;
> Tiboquery.close;
> Tiboquery.params[0].value := 'ZZZ';
> showmessage('before open:'+Tiboquery.params[0].asstring);
> Tiboquery.open;
> showmessage('after open:'+Tiboquery.params[0].asstring);
>
> first I click bitbtn1, then
> I click bitbtn2.
> the message as follow:
> [before open:ZZZ]
> [after open:623]
>
> Does anyone know this problem before?
>
> Kadee Aon