| Subject: | more problem with Ado Parameters |
| Posted by: | Kim Pedersen (k…@fanless.dk) |
| Date: | Sat, 19 Dec 2009 |
Hi
In some old designs (BDE) we were used to reuse the
Query to like this :
qry := TQuery.Create(nil);
...
...
qry.SQL.Text := 'SELECT cprnr FROM xxx';
some parameter set up etc.
open
use the return dataset
qry.close;
qry.sql.text := 'Insert into bla bla.. with some parameters';
qry.sqlexec;
now the ADO Parameter do not clear the parameters on close or then sql.text
are set again,
so Ado comes up with an error indicating that parameters are not correct .
Why in world are parameters not cleared when the qry text are changed.
Am I missing something here ?
Best regards
Kim Pedersen