I think you have multiple issues with this SQL Statement. I don’t think you can select a COUNT(*) along with other fields in the same SQL Statement; Count returns a number, not an array. While the fields return an array.
In addition to that, what is 'HAVING Count(*) > 1' supposed to do? And then as already mentioned you were missing the : before the variable. See also: http://livedoc.4d.com/4Dv15/help/Command/en/page18316.html -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
