Miyako,

Many thanks!

Randy Engle

-----Original Message-----
From: 4D_Tech <[email protected]> On Behalf Of Keisuke Miyako via 
4D_Tech
Sent: Tuesday, February 5, 2019 4:30 PM
To: 4D iNug Technical <[email protected]>
Cc: Keisuke Miyako <[email protected]>
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 
<[email protected]<mailto:[email protected]>>のメール:

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:[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]
**********************************************************************

Reply via email to