Master-Detail-Template
I try to built an end-user-application like \...\II. Applicatons\03.
End-User with Data Dictionary. I have create a master-detail-report for
invoices, the preview looks fine, and so i save it to the database. But if i
load the template in my program, every master (order) has all the same
details (items of all orders). What do i make wrong? I work with Delphi 5
and Paradox and try to understand RB 6.03. Simple lists in the preview of
my beginning end-user-application and in my application with
LoadFromDatabase looks fine.
End-User with Data Dictionary. I have create a master-detail-report for
invoices, the preview looks fine, and so i save it to the database. But if i
load the template in my program, every master (order) has all the same
details (items of all orders). What do i make wrong? I work with Delphi 5
and Paradox and try to understand RB 6.03. Simple lists in the preview of
my beginning end-user-application and in my application with
LoadFromDatabase looks fine.
This discussion has been closed.
Comments
form that may be getting hooked up to the report? Are the subreport
connected to the respective detail dataviews? They should be assigned since
they were saved down with the dataviews in the template.
Can you create a new test program and see if you can load it into that one?
If you can and it still doesn't work, then check the SQL that is being
generated after you load the template to your program. Use the designer and
DADE at runtime to do this (Add daIDE and daDBBDE to you uses clause).
Control-mouse click over the detail dataview. You should get a window and
you should see the SQL in this window that is built to support the master
detail dataset for that dataview. How does this SQL look in the detail
dataviews?
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com