May I kindly suggest reading a basic primer on SQL. > Date: Wed, 1 Nov 2017 17:15:01 +0000 > From: Timothy Penner <[email protected]> > > 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:[email protected] **********************************************************************
