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

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

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

*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