Subject | Why TIBOQuery.params[0].value change after open? |
---|---|
Author | Kadee |
Post date | 2003-05-02T09:12:28Z |
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
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