N
Norm Viste
In FP 2003 DRW query, I want to show a distinct list of entries from one
field when another field has only a specific entry.
fp_sQry="SELECT DISTINCT category FROM wishlists where person = :
erson::"
produces only a blank list of categorys.
fp_sQry="SELECT category FROM wishlists where person=:erson::"
also produces only a blank list of categorys.
fp_sQry="SELECT * FROM wishlists where person=:erson::"
where list is edited to show only category field, produces all categorys
from person, but including duplicates. I want to eliminate duplicates.
fp_sQry="SELECT DISTINCT category FROM wishlists "
Shows a distinct list of categorys from all persons in wishlist.
Various combinations of parentheses don’t seem to help.
field when another field has only a specific entry.
fp_sQry="SELECT DISTINCT category FROM wishlists where person = :
erson::"produces only a blank list of categorys.
fp_sQry="SELECT category FROM wishlists where person=:
erson::"also produces only a blank list of categorys.
fp_sQry="SELECT * FROM wishlists where person=:
erson::"where list is edited to show only category field, produces all categorys
from person, but including duplicates. I want to eliminate duplicates.
fp_sQry="SELECT DISTINCT category FROM wishlists "
Shows a distinct list of categorys from all persons in wishlist.
Various combinations of parentheses don’t seem to help.