Basically createa direct access to all the child tables. On Sunday, March 15, 2015, Mike Doub <[email protected]> wrote:
> Would it not be better to make the child table into an array indexed by > its ID, then make a single pass thru the parent table using the child ID > into the array. > > Mike > > On Sunday, March 15, 2015, Keith Clarke <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> Folks, >> Is there a ‘smart’ way to denormalise ‘child' & ‘parent' CSV tables >> extracted from an RDBMS in LiveCode or is it down to iterating through >> lists using chunk functions? >> >> I have four tables, related in the database as >> Child-Parent-GrandParent-GreatGrandParent. Each file has its own record ID >> & the ID of its direct parent. I need to create a ‘DenormalisedChild' file >> with GrandParent & GreatGrandParent IDs appended to each row. >> >> I’m currently assuming the only way forward is to build a >> tDenormalisedChild variable by repeated iteration at each ‘level’: >> Iterating through lines of the Child file to compare its ChildParentId >> with each row in the the Parent file, until ParentRowId = ChildParentId; >> Repeat (1) on Parent file rows to find ParentGrandParent values; >> Repeat (1) on GrandParent file rows to get GreatGrandParent values >> >> Is their a more efficient approach? >> Best, >> Keith.. >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
