TUniQuery

[Suhaimin]

Hello,


I have a Table Customer (CustomerNO,Name )Primary Key : customerno
data Customer : 1 ,one
2 , two


then a Table Sales (Salesno,Date, CustomerNo) SalesNo is Primary Key.
data sales : 001, 2013/7/1, 1
002, 2013/7/1, 1
003,2013/7/1, 2


qryCustomer.SQL.Text := 'SELECT * FROM Customer';


qrysales.SQL.Text := 'SELECT * FROM Sales WHERE CustomerNo = :CustomerNo';


qryCustomerdatasource.DataSet := qryCustomer;
qrysales.MasterSource := qryCustomerdatasource;

qrycustomer.open;
qrysales.open;

why after qrysales.open i can not see any record ini qrysales even if i move to another customer ? whats happened in qrysales? thanks a lot.

[isysoftware]

I think because QrySales has a WHERE clause...

[stevel]

On the detail dataset (qrySales), in addition to the MasterSource property, you need to also set the MasterFields property (clicking on the ... button in property editor will open a dialog window where you can do this. This will also set the DetailFields property).

[DemetrionQ]

Hello.

I couldn't reproduce the issue. Please provide the following information:
  - the server version;
  - a simple project demonstrating the problem.
You can send me this information to dmitryk*devart*com

[Suhaimin]

hello,

problem solved.. thanks for All...

[DemetrionQ]

If any other questions come up, please contact us.