Jeff, Many thanks,
Yes, I playing with the "IN" function Randy Engle Internet – Hosted – In the Cloud: On-line Backflow Test Entry! XC2Live! - Backflow Program Management Operational Now! – Call for additional information: 800.761.4999 -----Original Message----- From: 4D_Tech <[email protected]> On Behalf Of Jeffrey Kain via 4D_Tech Sent: Wednesday, September 18, 2019 9:44 AM To: 4D iNug Technical <[email protected]> Cc: Jeffrey Kain <[email protected]> Subject: Re: QUERY WITH ARRAY - SQL Equivalent? SELECT ... FROM Table WHERE [ID] in ( comma separated list of IDs ) ID is a reserved word in sql so if that’s the name of your field you need to escape it (I use brackets in 4D). ********************************************************************** 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] ********************************************************************** ********************************************************************** 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] **********************************************************************
