Skip to Content
0
Former Member
Oct 07, 2005 at 12:40 PM

Reading table struc

172 Views

Hi,

I have a function that returns me table Struc. I am trying to create another table by going through this table. The new table would contain the ObjectID and the ObjectID of its parent.

In order to find the parent first we have to look at the PUP column corresponding to the Object. This PUP is then matched with another column in the same table SQNR. If PUP = SQNR then we grab the ObjectID corresponding to that SQNR and this is the parent.

What would be an efficient way of achieving this? I would really appreciate the help!!

Thanks.