that explains the fact that a restart of 4D fixed the issue!
On Wed, 1 Nov 2017 16:10:46 -0500, Richard Wright via 4D_Tech wrote: > I’ve seen Nested Begin/End SQL errors when a previous statement did > not complete. If you get an error and then abort the code it’s left > open and the next time you try to run you get this kind of error. > > ------------------------------------------------ > Richard Wright > DataDomain > rwri...@datadomainsoftware.com > ―――――――――――――――――――――――― > >> Date: Wed, 1 Nov 2017 10:48:29 -0600 >> From: David Witton <dhwit...@gmail.com> >> >> 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 > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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 **********************************************************************