I need my People to have non null dates of birth for uploading a gedcom to Ancestry, otherwise the person is marked as living. I have baptism dates and want to edit the birth date to the year of baptism. I did a sql query and enabled editing. I then went down each entry and entered the year of birth by hand in the birth date field from the baptism date. However these have not been saved. They are still there in the query window but do not show up in the person's profile. ( I put abt in front of the year but even without the abt it doesn't save). What am I doing wrong?
I suspect there may be a clever alternative way to change these en masse with an sql statement but that would be beyond me!
enable editing not updating field
Moderator: Nick Hunter
-
- Posts: 669
- Joined: Sun Dec 18, 2005 9:36 am
- Location: SpanSoft, Scotland
- Contact:
Re: enable editing not updating field
Hi,
This appears to be a limitation of all date fields. The field which is displayed in the query results is actually the descriptive version of the birth date, not the underlying date itself. So by editing this field you are not actually editing the underlying date.
We will take a look at this and see if it is possible to implement date editing in the next program update.
This appears to be a limitation of all date fields. The field which is displayed in the query results is actually the descriptive version of the birth date, not the underlying date itself. So by editing this field you are not actually editing the underlying date.
We will take a look at this and see if it is possible to implement date editing in the next program update.