Devart Forums

I use the SDAC components access to the database SQL Server.

I'm having a problem related to existing master / detail. I have a query (detail) in which the property MasterSource is linked to the datasource query master:

Query Detail:
"SELECT * FROM TABLE_DETAIL WHERE FIELD_DETAIL = :FIELD_DETAIL"

Query Master:
"SELECT CODE, FIELD_DETAIL FROM TABLE_MASTER"

When the value of the "FIELD_DETAIL" Query the master is changed, you need to change the parameter value "FIELD_DETAIL" Query of detail. Using Query_Detail.Refresh, the parameter is not updated, but using Query_Detail.Close / Query_Detail.Open the parameter is updated. Should not the "Query_Detail.Refresh" update this parameter? PS: The components of the Query's ZEOS / BDE make this update parameter after the command "Refresh"

Thank you,
Fábio

PS: Sorry for my English

I can not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.
Also specify the exact version of SDAC you are using.