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 [email protected] ———————————————————————— > Date: Wed, 1 Nov 2017 10:48:29 -0600 > From: David Witton <[email protected]> > > 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 < > [email protected]> wrote: > >> No “:” in front of $arrCount? >> >> Milan >> >> Sent from my iPad >> >>> On Nov 1, 2017, at 17:04, David Witton via 4D_Tech <[email protected]> >> 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:[email protected] **********************************************************************
