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 First, I copied it directly from another method in the same DB that references another table. I just changed the table and field names- that method works correctly. Next, I retyped the block from scratch - still the same result. Any ideas on what to try next are welcome. -- 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:[email protected] **********************************************************************
