We are migrating a large number of apps built in Delphi 2006 to Delphi 10.1.2 Berlin.
We have encountered an issue that we have been unable to resolve. We use Parameters to connect Master to Detail ADOqueries.
This has resulted in random errors when the Adoquery attempts to open indicating missing or invalid Parameters or parameter values.
These errors do not happen all then time and is difficult to re-produce.
Is there any specific changes required to use Parameters reliable with ADO components in XE10?
Example with no Master Datasource set.
qryFees.sql.text:='SELECT * FROM FEETBL WHERE REF_KEY = :REF_KEY';
qryFees.Parameters.ParamByName ('REF_KEY').Value := _PVNbr;
If most cases were have a childQry with it Datasource Property set to the Masterqry. The SQL for the childQry looks like
Childqry.sql.text:='SELECT * FROM CHILDTBL WHERE MASTERKEY = :MASTERKEY'
Where MASTERKEY is common field between child and master
Where do have the ParamCheck Property CHECKED on the AdoQuery commponents that have Parameterized SQL
Were do not checked the Prepaired checkbox. Should we do this?