ado设置好主从表后,DELPHI自动设置IndexFieldNames,如果我在运行时候修改,则主从关系会不正确,如何解决? ( 积分: 299 )

H

hsgrass

Unregistered / Unconfirmed
GUEST, unregistred user!
ado设置好主从表后,DELPHI自动设置IndexFieldNames,<br>如果我在运行时候修改,则主从关系会不正确,<br>例如:<br>M表与D表使用areacode作为主从关系,如果设置从表的INDEXDIELDNAMES为<br>custcode则从表与主表生成的<br>FieldExpr&nbsp;:=&nbsp;GetFilterStr(LinkField,&nbsp;TField(MasterDataLink.Fields).Value);<br>为新的字段的值,<br>即masterfilds与INDEXDIELDNAMES必需相同,才能有主从关系,但DELphi的說明,是它不是必需的,只是提高性能。。。<br>Lists&nbsp;the&nbsp;columns&nbsp;to&nbsp;use&nbsp;for&nbsp;a&nbsp;persistent&nbsp;sort&nbsp;of&nbsp;the&nbsp;recordset.<br>Delphi&nbsp;syntax:<br>property&nbsp;IndexFieldNames:&nbsp;String;<br>IndexFieldNames&nbsp;may&nbsp;be&nbsp;used&nbsp;to&nbsp;set&nbsp;the&nbsp;sort&nbsp;order&nbsp;for&nbsp;the&nbsp;detail&nbsp;table&nbsp;in&nbsp;a&nbsp;master-detail&nbsp;link,&nbsp;increasing&nbsp;the&nbsp;performance&nbsp;of&nbsp;the&nbsp;link.&nbsp;However,&nbsp;use&nbsp;of&nbsp;IndexFieldNames&nbsp;is&nbsp;not&nbsp;required&nbsp;for&nbsp;master-detail&nbsp;links.<br><br>有没有解决办法?
 
还是自己动手解决比较快。。。。。。<br>恢复INDEXFIELDNAMES+BOOKMARK就解决了。。<br><br>需要分的朋友顶下,谢谢
 
顶部