Search function

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
donne
Posts: 80
Joined: Wed Dec 28, 2005 12:46 pm
Location: UK
Contact:

Search function

Post by donne » Tue Aug 17, 2010 12:27 pm

Search doesn't seem to work as I expect it to. For example I am trying to find a family relating to the death of a widow called say Jane Smith. I open the Search/ Family window and put 'smith' in the father's surname box and 'jane' in the mother's firstname box, and select 'match all fields'. The result seems to be any family with a father 'smith' plus any family with a mother 'jane' . It's the same result I get with 'match any field', where I would expect it.

laschapas
Posts: 74
Joined: Tue Jan 24, 2006 9:48 am
Location: Derbyshire, UK

Post by laschapas » Tue Aug 17, 2010 8:24 pm

I get the same results using the Families Tab search.

It does work ok. as an SQL Query with partial match set. Try :-

SELECT Families.[Description], Families.[Fathers name], Families.[Mothers name]
FROM Families
WHERE ( UPPER(Families.[Fathers name]) LIKE '%SMITH%' ) AND ( UPPER(Families.[Mothers name]) LIKE '%JANE%' )

The [Match all fields] & [Match any fields] selection does then make a difference to the results.

John Wood

donne
Posts: 80
Joined: Wed Dec 28, 2005 12:46 pm
Location: UK
Contact:

Post by donne » Sat Aug 21, 2010 11:09 am

Thanks for that. SQL Query does what I want and I can code the query using the setup table in the window - you can see how the AND and OR function in the query text changes as you select 'Match any field' or 'Match all fields'. I presume in the Search/Family window, the underlying SQL Query text for 'Match all fields' is not being formed properly?

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

Post by Nick Hunter » Tue Feb 15, 2011 9:10 am

This was fixed in V3.1.1

Post Reply