Board index » delphi » D7_upd1 cds.Params problems...
D7_upd1 cds.Params problems...
2004-09-16 07:33:55 PM
After updating Delphi 7 with Update 1 some things are broken
1) I can understand that
Basically, the problem is that the provider now tries to detect if the
cds parameters have changed so it doesn't have to reassign them to the
dataset which would force the dataset to close and break the incremental
but NOT this
2) Same Param Values but on different tables i.e. changing CommandText -
just the table name but Params and Values stay the same. Why then still
the same behavior? What does it have to do with incremental fetch - I
don't use incremental fetch?
D7 ent. w/ Upd1 (build 8.1), MySQL 4.0.18 and standard set of controls
cds.Active := False;
if(ComboBox1.ItemIndex = 0) then
cds.CommandText := 'SELECT * FROM tbl1 WHERE month = :n ORDER BY
cds.CommandText := 'SELECT * FROM tbl2 WHERE month = :n ORDER BY
cds.FetchParams; // Params.Clear ... nothing helps
cds.Params.ParamByName('n').AsString := DateToStr(DateTimePicker.Date);
cds.Active := True; // here cds sends request thru dsp ->sqlDataSet
// Throws exception here either 'Cant find field n' or 'Param has no
value' depends on how I tried to ReSet it.