Hi Chuck, I’m wondering whether the crash is related to HAVING. Have you tried it without HAVING to do the subquery? Would it work to simply change HAVING to AND? I guess I could set up a test system to try it out, but I’m lazy.
The 4D docs claim that HAVING should work without a GROUP BY.\, so my suggestion is likely a long shot. Tom Benedict ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************