Code: Select all
select distinct PartNumber from WEBSITE where PartNumber in (select PartNumber from WEBSITE where PartNumber != \"\" group by PartNumber having (COUNT(PartNumber) > 1)) order by PartNumber;
And this has always worked for me over the years. However after updating wxWidgets (f1425dad131cd44d49ce5182378738b685fcac66) and wxSqlite (957d0c5c129bc5d1a98236a3f135a9ff626b8b43) to their current Master trunk versions. This now gives me an error saying "No such column"
What's odd is that simpler statements work fine. So "select PartNumber from WEBSITE;" works. It seems like whenever there is nested queries it fails with that error. But yet if I use the command line utility programs for SQLite3 and paste in:
Code: Select all
select distinct PartNumber from WEBSITE where PartNumber in (select PartNumber from WEBSITE where PartNumber != "" group by PartNumber having (COUNT(PartNumber) > 1)) order by PartNumber;
I've attached an sqlite3 db file that just has the table name WEBSITE with a column called PartNumber so you can try this out yourself.
Any help would be appreciated. Thanks!
Oh, this on windows 7 home, and using mingw64 configured as: i686-8.1.0-posix-sjlj-rt_v6-rev0