Search function
Moderator: Nick Hunter
Search function
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.
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
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
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?
-
- Posts: 669
- Joined: Sun Dec 18, 2005 9:36 am
- Location: SpanSoft, Scotland
- Contact: