GENBOX-L Archives

Archiver > GENBOX > 2003-05 > 1053264242


From: "wim prange" <>
Subject: RE: [GENBOX] Version 3.0.21 Released (Query incorrect after Repair)
Date: Sun, 18 May 2003 15:24:24 +0200
In-Reply-To: <000f01c31d30$df508e20$4240880a@BILLXP>


I can live with this,

Wim

> -----Oorspronkelijk bericht-----
> Van: William T. Flight [mailto:]
> Verzonden: zondag 18 mei 2003 13:30
> Aan:
> Onderwerp: Re: [GENBOX] Version 3.0.21 Released (Query incorrect after
> Repair)
>
>
> > 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
> >
> >
> >
>
>
>
> ==== 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: