Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
master detail - controlling sort order ? |
Mon, Dec 12 2016 6:27 AM | Permanent Link |
kamran | Hi
Any known solutions to this problem? if I have 3 tables all linked together in a master detail relationship. table1 = page table2 = header table3 = line eg. line linked to header, header linked to page. So I need to control the "Sort" order of the line *without affecting" master detail relationships. How is this possible using edb ? Thanks Kamran |
Mon, Dec 12 2016 7:05 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | kamran
I think its a TDataset restriction so as you describe it - no. What you can do is accept that you need to make the selections yourself - either use a parameterised query or a table with a filter changing when the id of the header table changes. Neither will be as fast as a master-detail relationship (memory says it sets a range which is why the restriction on the index being the linkage), but will still be pretty fast. I have a similar requirement and use this approach a lot. If you need to edit the line either use a table & filter or make sure the query is sensitive. I have a feeling that there is a way to use a query in a master-detail but have never used it. If there is I'm sure someone else will contribute. Roy Lambert |
Mon, Dec 12 2016 7:33 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kamran,
<< So I need to control the "Sort" order of the line *without affecting" master detail relationships. How is this possible using edb ? >> Yes, but you'll have to use TEDBQuery component instead of TEDBTable components. See here for more information: http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphi&version=XE&comp=TEDBQuery&prop=DataSource Be sure to set the TEDBQuery.RequestSensitive property to True and follow these rules: http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Result_Set_Cursor_Sensitivity in order for the detail datasets to be editable. Tim Young Elevate Software www.elevatesoft.com |
Mon, Dec 12 2016 8:22 AM | Permanent Link |
kamran | *thanks* to all
I will give it a go Tim Young [Elevate Software] wrote: Kamran, << So I need to control the "Sort" order of the line *without affecting" master detail relationships. How is this possible using edb ? >> Yes, but you'll have to use TEDBQuery component instead of TEDBTable components. See here for more information: http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphi&version=XE&comp=TEDBQuery&prop=DataSource Be sure to set the TEDBQuery.RequestSensitive property to True and follow these rules: http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Result_Set_Cursor_Sensitivity in order for the detail datasets to be editable. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |