RE: 4D Selection from SQL Query

2019-02-06 Thread Randy Engle via 4D_Tech
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 Subject:

RE: 4D Selection from SQL Query

2019-02-05 Thread Randy Engle via 4D_Tech
Miyako, Many thanks! 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 Subject: Re: 4D Selection fr

Re: 4D Selection from SQL Query

2019-02-05 Thread Keisuke Miyako via 4D_Tech
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

RE: 4D Selection from SQL Query

2019-02-05 Thread Randy Engle via 4D_Tech
Chuck, Many thanks! ( I hunched that I'd hear from you on this one. ) It is as I expected: ce n'est pas possible Except as you showed in your example (Which has a little bit of merit for what I'm thinking about doing) Thanks!  Randy Engle It is not possible. If you really need it, it

Re: 4D Selection from SQL Query

2019-02-05 Thread Charles Miller via 4D_Tech
It is not possible. 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 query with array([table]primary_key;$primaryKeyArray) Don't know why you would do this except you could build sql where