Hello SQL Afficionados! I need to get a selection of records, based upon an array of ID numbers. (What I want is to end up the arrays... not the selection of records)
e.g. QUERY WITH ARRAY([Personnel]Personnel_ID;al_Personnel_ID) The above works just great! "Except", that it changes the current selection and current record. Whereas, what I really want is to end up with a half dozen or so arrays from the [Personnel] Table, without touching the current selection/record. I'm using 4D 16r6 (Windows) Anyone know of a SQL function that does this? Or some other method. "Execute on Server" attribute would work, except in many cases these are single-user systems, not client/server. Gracious thanks to all Randy Engle ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
