Page 1 of 1

Problem with Mastersource, what I'm doing wrong?

Posted: Mon 12 Feb 2007 11:17
by gilbert3
Please let me know what I'm doing wrong:

0. MyDac 4.40.022 std, delphi 7.
1. I've got two tables named: open_year_quatity and current_quantity
2. Tables are the same and contains all fields which are in other. They contains all data the same except one difference - field Quantity - it is obvious.
3. open_year_quantity in Mytable has mastersource property set to Dataset which contains table current_quantity.
4. Fields are indeks(string), price(real8:2), stock(string) and quantity(real8:3) - they are linked with masterfields to the detailfields.

tell me what I'm doing wrong that dbgrid with open_year_quantity table is not displaying everytime records which are selected in dbgrid with current_quantity. Sometimes they are display, sometimes not. Don't know why.

Posted: Tue 13 Feb 2007 09:31
by Antaeus
Probably the reason of this problem is in usage of the float fields for master/detail relationship. The problem happens because of float values inaccuracy. If you are sure that the problem is not in float fields, send me at evgeniyd*crlab*com a complete small sample to reproduce it including script to create and fill table. Also supply us with exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.