enable editing not updating field

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
Posts: 14
Joined: Wed May 13, 2009 11:23 am
Location: United Kingdom

enable editing not updating field

Post by sdj » Fri May 15, 2015 11:09 am

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!

Nick Hunter
Posts: 669
Joined: Sun Dec 18, 2005 9:36 am
Location: SpanSoft, Scotland

Re: enable editing not updating field

Post by Nick Hunter » Fri May 15, 2015 11:39 am


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.

Post Reply