Jay's original question was about which field in the database contained the
child status. That is why I provided a few SQL scripts that make use of those
fields in the database tables. I was aware of the methods available in Legacy.
If you try the scripts that I posted, you will find
I don't know a thing about SQL other than how to copy someone else's script
g. So your response meant nothing to me.
From his question it looked like he wanted to find those who were marked
twins.
Easy to find siblings with the same name - look in the Name List or
Children's List!
Finding
Hey Ron,
The intent behind my original question was that I was going to find a way
to find the persons in my database who are twins, BUT that I have not yet
marked as twins. And I did not know what table or field I would need to
change.
I have since discovered that the flag is the IDCS field
Ron said
I also have another script that can find possible multiple births that
have the child status blank and help to get those child status fields set
to Twin, Triplet, etc.
This is what I refereed to
Would love to get this from you.
Thanks
Jay
On Tue, Jul 8, 2014 at 8:11 AM, Ron
which was
What field changes in the database?
Not, How to do a search...
But thanks for taking the time to respond.
On Mon, Jul 7, 2014 at 9:56 PM, Sherry/Support she...@legacyfamilytree.com
wrote:
That wasn't your original question!
Sincerely,
Sherry
Technical Support
Legacy Family
On 08 Jul 2014 21:00, Jay 1FamilyTree wrote:
I have since discovered that the flag is the IDCS field within the tblCR.
In my file changing that from the default of 0 to a 6 will set them as a Twin.
The setting for Adopted is a 5 and Quadruplets is 8, not sure yet what it
should
be for
YES, CORRECT, that is why I said In my file
Like many other things in Legacy, the numbering of some fields is different
in each users database.
On Tue, Jul 8, 2014 at 1:22 PM, Mike Fry emjay...@gmail.com wrote:
On 08 Jul 2014 21:00, Jay 1FamilyTree wrote:
I have since discovered that the
Jay,
You are probably aware that tblCS is not standard for all users. It contains
whatever the user has added or retained from the original install. So changing
the value from 0 to 6 may not the Twin setting for all databases. What I do
is determine the value I want for the specific database
When I change a child status from the default of '_' to 'TWIN',
What field changes in the database?
I cannot see any changes in the IR table for Individuals
Or is there somewhere else I should be looking?
Thanks for any help
Jay
Legacy User Group guidelines:
Jay,
This first script is one that I developed to locate duplicate siblings in the
database. These are situations where a child is given a name that the parents
want but then dies early so they give the same name to another child.
Sometimes more than twice. It illustrates the connection of
Isn't it easier to just do a Search on the Detailed Search tab
Look for whom? Individual
Where to look Child Status
How to lookEqual to
What to look for Twin
Of course, this is assuming you have twins flagged with child status
And of course, you can find
Thanks Sherry,
But That doesnt answer my question, as I intend on using a SQL search to
update all the ones that are not flagged as twins.
I need to look thru the fields in the CP, CR and CS tables, It must be set
there.
On Mon, Jul 7, 2014 at 9:18 PM, Sherry/Support
That wasn't your original question!
Sincerely,
Sherry
Technical Support
Legacy Family Tree
On Mon, Jul 7, 2014 at 9:47 PM, Jay 1FamilyTree 1familytree@gmail.com
wrote:
Thanks Sherry,
But That doesnt answer my question, as I intend on using a SQL search to
update all the ones that are
13 matches
Mail list logo