Milan Thanks - after I posted, I caught that and corrected, but still get the same error.
On Wed, Nov 1, 2017 at 10:06 AM, Milan Adamov via 4D_Tech < 4d_tech@lists.4d.com> wrote: > No “:” in front of $arrCount? > > Milan > > Sent from my iPad > > > On Nov 1, 2017, at 17:04, David Witton via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not > > allowed. > > > > Begin SQL > > SELECT Athena.First_Name, Athena.Last_Name, Athena.DOB, Count(*) as > recCount > > from Athena > > Group by Athena.First_Name,Athena.Last_Name,Athena.DOB > > HAVING Count (*)>1 > > into :$arrFld1,:$arrFld2,:$arrFld3, $arrCount; > > End SQL > > > > > ********************************************************************** > 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 > ********************************************************************** -- David Witton ********************************************************************** 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 **********************************************************************