M
Mettá
I have what seems like a real problem
I had a drop down DRW using DISTINCT to show all records containing matching
records from a separate record set. SO one table containing various records.
Say Names, Description, County, etc It has worked fine for over two years!
The drop down did show all distinct "County" records where there was a
"Description" containing specific text.
When I modify the sql with Distinct as;
SELECT DISTINCT County FROM XTableName WHERE (Description LIKE
'%:
escription::%') ORDER BY County ASC
is no longer working but if I revert to the standard query of
SELECT * FROM XTabeName WHERE (Description LIKE '%:
escription::%') ORDER
BY County ASC
It works but of course I get duplicates in the drop down.
Can anyone shed any light on why this might be happening.
Thanks
M
I had a drop down DRW using DISTINCT to show all records containing matching
records from a separate record set. SO one table containing various records.
Say Names, Description, County, etc It has worked fine for over two years!
The drop down did show all distinct "County" records where there was a
"Description" containing specific text.
When I modify the sql with Distinct as;
SELECT DISTINCT County FROM XTableName WHERE (Description LIKE
'%:

is no longer working but if I revert to the standard query of
SELECT * FROM XTabeName WHERE (Description LIKE '%:

BY County ASC
It works but of course I get duplicates in the drop down.
Can anyone shed any light on why this might be happening.
Thanks
M