0 Replies - 748 Views - Last Post: 06 April 2009 - 10:26 AM Rate Topic: -----

#1 rkhunter   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 18
  • Joined: 03-March 09

MSDataShape - Relation Hierarchy (error: Item cannot be found...)

Post icon  Posted 06 April 2009 - 10:26 AM

Hi guys,

Is anybody can help me to resolve my problem using the MSDataShape in VB6? here's the scenario:-


My tables and the fields
JnlTemp
- GLAcctID
- SLAcctID
AcctRegGL
- GLAcctID
- GLAcctName
AcctRegSL
- GLAcctID
- SLAcctID
- SLAcctName

My aim is to relate:-
JnlTemp(GLAcctID) to AcctRegGL(GLAcctID,GLAcctName)
JnlTemp(SLAcctID) to AcctRegSL(GLAcctID,SLAcctID,SLAcctName)

Here's my code:-
adoEntryDTL.Open "SHAPE {SELECT GLAcctID,SLAcctID from JnlTemp} APPEND ((SHAPE {select GLAcctID,SLAcctID,SLAcctName from AcctRegSL} APPEND ({select GLAcctID,GLAcctName from AcctRegGL} AS AcctRegGL RELATE GLAcctID TO GLAcctID)) AS AcctRegSL RELATE SLAcctID TO SLAcctID)", db, adOpenStatic, adLockOptimistic

Here's the error encountered:-
Item cannot be found in the collection corresponding to the requested name or ordinal

Please kindly check IF my code is correct, please advice...

Please HELP... thank you very much in advance

Rgds.
rkhunter

Is This A Good Question/Topic? 0
  • +

Page 1 of 1