Parameter - Master/Detail

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
moraes.fabiojr
Posts: 1
Joined: Wed 30 Dec 2009 01:38

Parameter - Master/Detail

Post by moraes.fabiojr » Wed 30 Dec 2009 02:04

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

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 30 Dec 2009 08:07

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.

Post Reply