At 10:22 PM 29/09/2003 +0200, you wrote:

>Helen, could you provide a bit detailed information for this reference by
>ParamByName (in SQL there is no parametrised value, but there is a
>master-detail relationship).
>I don't know how to correct such error - what properties to check :-(
>Would be greateful for ideas

Use Delphi's tracing and the SQL Monitor to observe what's going on.

Best I can offer is that you examine the MasterLinks property of the detail
set and see whether the param name mismatch is occurring there.

For example, if the detail's masterlink points to
Table1.P_Key then the link won't work if you change the master table to
Table2, even if Table2 has a column called 'P_Key'. Set the detail's
Mastersource and MasterLinks properties to nil before you start messing
with the master set.

Helen