DisableControls stops Dataset first, next, connection to Master DB from working
Original Reporter info from Mantis: RCrosser
-
Reporter name: Russell Crosser
Original Reporter info from Mantis: RCrosser
- Reporter name: Russell Crosser
Description:
Help about on Lazarus - Lazarus 2.0.10 r63526 FPC 3.2.0 x86_64-win64-win32/win64
I have a master-detail, one master, 2 dependent tables. When I try to traverse the database with the controls disabled, the
dependent tables do not correctly display. As I move through the master records, the details show the records for the
Master record I had highlighted before clicking the button to start.
Steps to reproduce:
Dataset has 3 tables, Company, Tranch, and Dividend.
Master Query (SQLQuery1Co) has no dataset associated
Master SQL - select * from company
1st and 2nd detail queries (SQLQuery2Tr and SQLQuery3Div) both have dataset set to SQLQuery1Co
1st Detail SQL (SQLQuery2Tr) - select * from Tranch where Company_Link = :Co_id
2nd Detail SQL (SQLQuery3Div) - select * from Dividend where Company_Link = :Co_id
Co_ID is the Primary Key of the Master Table (Company)
I traverse the data in a simple procedure.
while not SQLQuery1Co.EOF do begin
SQLQuery1Co.First;
Print fields;
Show Tranches; // similar logic
Show Dividends; // similar logic
SQLQuery1Co.next;
end;
Additional information:
The details are in the attached program.
The faulty results are in BugResults.txt
Controls disabled: (the grouped lines are all the same)
AAA (Aaaaaa)
221 Units bought on 1/02/2019 Cost: $2221
222 Units bought on 1/02/2020 Cost: $2222
223 Units bought on 1/02/2021 Cost: $2223
Dividend 1/05/2019 Franked: $112.01 Unfranked: $12.01
Dividend 2/05/2020 Franked: $112.02 Unfranked: $12.02
Dividend 3/05/2021 Franked: $112.03 Unfranked: $12.03
BBB (Bbbbbb)
221 Units bought on 1/02/2019 Cost: $2221
222 Units bought on 1/02/2020 Cost: $2222
223 Units bought on 1/02/2021 Cost: $2223
Dividend 1/05/2019 Franked: $112.01 Unfranked: $12.01
Dividend 2/05/2020 Franked: $112.02 Unfranked: $12.02
Dividend 3/05/2021 Franked: $112.03 Unfranked: $12.03
Controls not disabled: (this is the correct data)
AAA (Aaaaaa)
111 Units bought on 1/01/2019 Cost: $1111
122 Units bought on 1/01/2020 Cost: $1112
113 Units bought on 1/01/2021 Cost: $1113
Dividend 1/04/2019 Franked: $111.01 Unfranked: $11.01
Dividend 2/04/2020 Franked: $111.02 Unfranked: $11.02
Dividend 3/04/2021 Franked: $111.03 Unfranked: $11.03
BBB (Bbbbbb)
221 Units bought on 1/02/2019 Cost: $2221
222 Units bought on 1/02/2020 Cost: $2222
223 Units bought on 1/02/2021 Cost: $2223
Dividend 1/05/2019 Franked: $112.01 Unfranked: $12.01
Dividend 2/05/2020 Franked: $112.02 Unfranked: $12.02
Dividend 3/05/2021 Franked: $112.03 Unfranked: $12.03
Mantis conversion info:
- Mantis ID: 38752
- OS: Windows 10
- OS Build: build 19041
- Build: Lazarus 2.0.10 r63526 FPC 3.2.0
- Platform: PC