I would modify as follows set query destination into a variable query table check variable
You might also query with array distinct values. If records in selection count = query with array count and distinct values count also equals, you have only one record each Regards Chuck ------------------------------------------------------------------------------------------------ Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmiller<AT SIGN>informed-solutions.com Brookline, MA 02446 USA Registered 4D Developer Providers of 4D and Sybase connectivity http://www.informed-solutions.com ------------------------------------------------------------------------------------------------ > On Sep 21, 2016, at 4:44 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > > Query([table][table]index_Field=value) > or > use set > Query selection([table];[table]Indexed_field=value) ********************************************************************** 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 **********************************************************************