Miyako Many thanks again! Works like a charm!
Took a couple of passes to see the "Double Underline" in the virtual field: __ROW_ID I'm going to take a W.A.G. that this is what QUERY BY SQL command is doing behind the scenes. Not sure how I'm going to use this, but I think it might come in handy at some point. Thanks again, Randy Engle, -----Original Message----- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Tuesday, February 5, 2019 4:30 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako <keisuke.miy...@4d.com> Subject: Re: 4D Selection from SQL Query alternatively, I guess we can SELECT __ROW_ID == record number (not all tables have a primary key). https://doc.4d.com/4Dv17/4D/17/Replication-via-SQL.300-3786654.en.html https://doc.4d.com/4Dv17/4D/17/CREATE-SELECTION-FROM-ARRAY.301-3729926.en.html 2019/02/06 3:31、Randy Engle via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: If you really need it, it would be a two step process. Step one Begin sql select primary_key form table where (some criteria) into :$primaryKeyArray end sql ********************************************************************** 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 ********************************************************************** ********************************************************************** 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 **********************************************************************
