[ivanyuzafatau]

I’ve done some research with the new version. I tried creating a custom named sorting index for the master table.

tMaster.AddIndex(‘Sort’, ‘Company’, [ixDescending]);
tMaster.IndexDefs.Update;
tMaster.IndexName := ‘Sort’;

The sort works on the master table. The index name remains as I specified it.

But similar code for a detail table has the following consequences:
1) master/detail relationship no longer works
2) the IndexName for the detail table changes to ‘__MT__DETAIL_’ if I navigate to another record in the master table

Can I hope this behavior will change in future versions of kbmMemTable?
Thank you!

[ivanyuzafatau]

For some reason, my previous comment is broken. I’ll try to add anew..

I’ve got one more question. I want to use my own index name. If I create and use a sorting index as follows:

kbmMemTable1.AddIndex(‘Sort’, ‘EmpNo’, [ixDescending]);
kbmMemTable1.IndexDefs.Update;
kbmMemTable1.IndexName := ‘Sort’;

It also doesn’t work in kbmMemTable v. 7.85.00. In kbmMemTable v. 4.08b this worked well.

I can send you a demo application that demonstrates the problem.

[ivanyuzafatau]

Kim, Thank you for the answer!

<span class=”JLqJ4b ChMk0b” data-language-for-alternatives=”en” data-language-to-translate-into=”ru” data-phrase-index=”2″>I’ve got one more question. I want to use my own index name.</span> If I create and use a sorting index as follows:

kbmMemTable1.AddIndex(‘Sort’, ‘EmpNo’, [ixDescending]);
kbmMemTable1.IndexDefs.Update;
kbmMemTable1.IndexName := ‘Sort’;

<span class=”JLqJ4b ChMk0b” data-language-for-alternatives=”en” data-language-to-translate-into=”ru” data-phrase-index=”2″>It also doesn’t work in kbmMemTable v.</span> <span class=”JLqJ4b ChMk0b” data-language-for-alternatives=”en” data-language-to-translate-into=”ru” data-phrase-index=”3″>7.85.00.</span> <span class=”JLqJ4b ChMk0b” data-language-for-alternatives=”en” data-language-to-translate-into=”ru” data-phrase-index=”4″>In kbmMemTable v 4.08b this worked well.</span>

I can send you a demo application that demonstrates the problem.

[ivanyuzafatau]

I will add to my question.

kbmMemTable1 is a detail table. tMaster is a master table.

tMaster.Active:=true;
kbmMemTable1.DetailFields:=’CustNo’;
kbmMemTable1.MasterSource:=dsMaster;
kbmMemTable1.MasterFields:=’CustNo’;

[Author]

Posts