Greg,
I may misunderstand your question, but if you have a field in the child file
that references the parent, and then create an index for this field on the
child file, it is fairly easy to create a subroutine to fetch the index values
from the parent file and translate them into whatever column(s) you want from
the child.
Then the parent can list values from the child with an itype like:
I
SUBR('*GETINDEXVALUES', childfilename, nameofindex, @ID (parent id) ); TRANS(
childfilename, childfilefield, @, 'X')
conversion
display name
format
M * must be "M'
The advantage of using a field and an index in the child file is that there is
always a way to "resync" the data if there is a problem; just rebuild the index.
The subroutine should use named common to hold on to the values of @time and
other arguments to buffer the result, since you do not want the returned list
to change if you are evaluating two+ columns child columns in a single report.
Also, be sure that the list returned from the subroutine contains value marks
rather than field/attribute marks.
You could replace the subroutine with a translation to the child file's
INDEX.nnn file, but such a structure would be much more fragile.
Rick Nuckolls
Lynden Inc
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, June 17, 2013 10:05 AM
To: U2 Users List
Subject: Re: [U2] How to copy only @ID from one file to anothers
I didn't think you could set up a foreign key dependency in UV?
The only thing I can think of would be to setup a trigger on the parent file,
That computes the ID that will be used in the child file and if it doesn't exist
Create in the child file.
This way, the parent file will push the @ID into the child file, whereas if you
Want to pull the @ID from the parent file, maybe setup a PHANTOM that runs every
Minute or so, but that won't guarantee that a record could be added to the
parent
File while the PHANTOM is sleeping between runs.
George
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Monday, June 17, 2013 12:43 PM
To: U2 Users List
Subject: Re: [U2] How to copy only @ID from one file to anothers
Guys,
I am attempting to create a store computed column data from a 'co' file.
How do I set this up so the stored computed column file "see" a new record
from the parent file? and how do I initially load the ID's?
Thanks,
Greg
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
