GENBOX-L Archives

Archiver > GENBOX > 2003-05 > 1053257416


From: "William T. Flight" <>
Subject: Re: [GENBOX] Version 3.0.21 Released (Query incorrect after Repair)
Date: Sun, 18 May 2003 07:30:16 -0400
References: <LJECKLFMNLFFEIMDFGGDKEHLDHAA.w.prange@chello.nl>


> 1) When doing a Repair/Compact and the Check Structure I get the following
> warning (in every database): "Data structure problems DETECTED: 1 Queries
> Incorrect. Correct these problems?" After clicking Yes (and the
confirmation
> that the problem was fixed) I repeat the Check Structure command and the
> warning is still there.

For performance reasons, Genbox stores a few subqueries in the database. The
"Check Structure" routine includes a check on these subqueries, doing a text
comparison. When a query doesn't match, the error message you described
appears; on repair, the correct query definition is stored to the database.
But there is a quirk in the way queries are stored; the Jet database engine
sometimes reorganizes the SQL clauses in an apparently random way. So while
the resulting SQL statement is equivalent, a text comparison to the original
will fail.

So for now, you can safely ignore this error message. I'll try to find a
better way to validate queries for the next release.

-- Bill

William T. Flight
http://www.thoughtfulcreations.com
----- Original Message -----
From: "wim prange" <>
To: <>
Sent: Saturday, May 17, 2003 10:46 PM
Subject: RE: [GENBOX] Version 3.0.21 Released


> Hi Bill,
>
> Thanks for the update: especially for expanding the searchcapabilities,
the
> exclude options for citations and the reports.
> A nice thought is the addition of the "Other" Sex type. Out of curiosity:
do
> you think we will be able to change an individuals sex at a certain time
in
> life in Genbox? The sex is now considered an attribute that is fixed for
> someones entire life. I think it will be nice to have reports for an
> individual that starts with male grammar (he, son, etc.) and after a
> "defining" sexchange-event ends in female grammar.
>
> There are a couple of items that need attention I think:
>
> 2) In the pick-list for citations, it's not possible to narrow down the
search
> with the Name-field (or the ID-field).
>
> 3) Sorting of several lists on Names doesn't work.
>
> Keep up the good work,
>
> Wim
>
> > -----Oorspronkelijk bericht-----
> > Van: William T. Flight [mailto:]
> > Verzonden: vrijdag 16 mei 2003 22:34
> > Aan:
> > Onderwerp: [GENBOX] Version 3.0.21 Released
> >
> >
> > Version 3.0.21 of Genbox Family History was released today. Both the
full
> > version and the patch file are available at
> > http://www.genbox.com/download.htm. Only the full version has the
updated
> > help file.
> >
> > This version has several enhancements and problem corrections. Among the
> > changes are improvements in the handling of non-individual lists and the
> > organization of what used to be known as "other" reports.
> >
> > If you have saved your own "Other" report options files, you will need
to
> > rename them if you want them to appear on the new custom report
submenus.
> > Change the lead word "Other" in the filename to "Individuals",
"Sources",
> > "Places", etc., depending on the custom report type.
> >
> > -- Bill
> >
> > William T. Flight
> > http://www.thoughtfulcreations.com
> >
> >
> >
> > ==== GENBOX Mailing List ====
> > If you have questions, comments or replies, please email them to
> > to have them added to this mailing list.
> >
> > ==============================
> > To join Ancestry.com and access our 1.2 billion online genealogy
> > records, go to:
> > http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237
> >
> >
>
>
> ==== GENBOX Mailing List ====
> If you have questions, comments or replies, please email them to
> to have them added to this mailing list.
>
> ==============================
> To join Ancestry.com and access our 1.2 billion online genealogy records,
go to:
> http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237
>
>
>


This thread: