[LegacyUG] Report for parents only one child

2014-07-08 Thread Jay 1FamilyTree
I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived mess

Re: [LegacyUG] Special characters

2014-07-08 Thread BobsTree2-Gmail
Re the Windows Czech keyboard Czech (Sorry, I could not resist it) out this article: http://superuser.com/questions/653404/how-to-type-czech-characters-on-windows-7-using-cs-language-with-us-internationa Bob Hansen > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.

Re: [LegacyUG] Special characters

2014-07-08 Thread johnbernacki1
I have been requesting more (Polish) special characters for a number of years and was very surprised and disappointed that they apparently are not added to Legacy 8. Legacy say that it would require major changes in their technology. I do not understand computer technology but since there are al

Re: [LegacyUG] Special characters

2014-07-08 Thread Sherry/Support
In order to insert Czech characters, you need to follow the instructions on the Czech website for a registry hack and some other changes. Only problem is you need to be able to read Czech to find the instructions! Sincerely, Sherry Technical Support Legacy Family Tree On Tue, Jul 8, 2014 at 5

Re: [LegacyUG] Special characters

2014-07-08 Thread Gene Wheeler
Interesting idea! Thanks! Gene On Tue, Jul 8, 2014 at 7:43 PM, BobsTree2-Gmail wrote: > Try using a Czech keyboard. > > I switch to a Danish keyboard for about six characters, and back to > English. Just a quick mouse click to switch between keyboards after set > up. > > Note, doing this on

Re: [LegacyUG] Special characters

2014-07-08 Thread BobsTree2-Gmail
Try using a Czech keyboard. I switch to a Danish keyboard for about six characters, and back to English. Just a quick mouse click to switch between keyboards after set up. Note, doing this on Windows 7, not sure when this feature was first available. Bob Hansen > Legacy User Group guideline

Re: [LegacyUG] Special characters

2014-07-08 Thread Gene Wheeler
Yes, I just figured that out. If I try to copy and paste a needed character, a "?" appears instead! Gene On Tue, Jul 8, 2014 at 7:35 PM, CE WOOD wrote: > Can of worms. See the archives. I don't know about Legacy 8, which is > still too buggy for me to use, but in Legacy 7.5, even if you copie

RE: [LegacyUG] Special characters

2014-07-08 Thread CE WOOD
Can of worms. See the archives. I don't know about Legacy 8, which is still too buggy for me to use, but in Legacy 7.5, even if you copied and pasted the correct characters, they would not show because Legacy doesn't use UTF-8 yet. CE Date: Tue, 8 Jul 2014 18:54:35 -0500 Subject: Re: [LegacyUG]

Re: [LegacyUG] Special characters

2014-07-08 Thread Gene Wheeler
Yes, but the needed characters are not there. I wonder if there is a way to expand or change the list from which the ribbon characters are chosen in Legacy. Gene On Tue, Jul 8, 2014 at 6:38 PM, Ron Taylor wrote: > Have you tried the "ribbon" for special characters as you enter data? > > > O

Re: [LegacyUG] Special characters

2014-07-08 Thread Ron Taylor
Have you tried the "ribbon" for special characters as you enter data? On Tuesday, July 8, 2014 5:18 PM, Steve Pick wrote: Copy it into wordpad and then just change the font size to want you want. Then copy into Legacy. I haven't tried it but I assume that works. On Tue, Jul 8, 2014 at 5:

Re: [LegacyUG] Special characters

2014-07-08 Thread Steve Pick
Copy it into wordpad and then just change the font size to want you want. Then copy into Legacy. I haven't tried it but I assume that works. On Tue, Jul 8, 2014 at 5:12 PM, Gene Wheeler wrote: > I have a lot of Czech names and locations that require the use of special > characters, many of whic

[LegacyUG] Special characters

2014-07-08 Thread Gene Wheeler
I have a lot of Czech names and locations that require the use of special characters, many of which are not available to choose for use within Legacy v.8. When I try to use these characters from the Windows Character Map, they display in a larger font than used in the various name, location, and n

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Ron Taylor
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 databas

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Jay 1FamilyTree
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 wrote: > On 08 Jul 2014 21:00, Jay 1FamilyTree wrote: > > > I have since discovered that the flag is the

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Mike Fry
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 T

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Jay 1FamilyTree
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 wrote: > That wasn't your original question! > > > > Sincerely, > Sherry > Technical Support > Legacy Family Tree > > > On Mon, Ju

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Jay 1FamilyTree
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 Ta

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Jay 1FamilyTree
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 withi

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Sherry/Support
I don't know a thing about SQL other than how to copy someone else's script . 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 indiv

Re: [LegacyUG] Child Status - TWIN

2014-07-08 Thread Ron Taylor
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 function