Re: SQL error

Tim Aside from the missing colon - which had been corrected - I also believe the statement is valid, since it's working in another method in the DB. To eliminate copy and past errors, I retyped the SQL block, but still got the error. What I didn't do is quit and restart 4D - after that the code

Re: SQL error

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, 20

SQL error

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,

identify duplicates

I'm looking for a strategy to identify duplicate records in a table - that is, records for which 3 fields are identical across two or more records - or in another case, where a single field is not unique. Does anyone have a suggestion on how to proceed? -- David Witton