How to programmatically create a selection

Kirk Brooks (6/2/14 4:58PM)
Stephen J. Orth (6/2/14 7:07PM)


Kirk Brooks (6/2/14 4:58 PM)

<<CAHY=XkuNtDJU9Vfjn+ScLg23ED=nBBqJ3+0Vdx6F5mX=L_V-rg@mail.gmail.com
>

I want to be able to create a series of selections of records in a
table.
For example, records in table = 400,000. I want to start at the top,
create
a selection of the first 20k records, export them, then select the next
20k, export them and so on.

I'm stumped.

--
Kirk Brooks
San Francisco, CA
==3D==3D==3D==3D==3D==3D==3D==3D==3D==3D==3D=

Stephen J. Orth (6/2/14 7:07 PM)

Kirk,

First thing that pops into my head is using Scan Index and Sets:

1. Scan index for first 20K
2. Create set A
3. Export data
4. Scan index for first 40K
5. Create set B
6. Do a "difference" on the two sets to get the next 20K 7. repeat
until processed.

There may be a simpler way, but that would be very fast.

Like I said, a quick thought....

Steve
-----Original Message-----
From: 4d_tech-bounces@...
[mailto:4d_tech-bounces@... On Behalf Of Kirk Brooks
Sent: Monday, June 02, 2014 6:59 PM

I want to be able to create a series of selections of records in a
table.
For example, records in table = 400,000. I want to start at the top,
create a selection of the first 20k records, export them, then select
the next 20k, export them and so on.

I'm stumped.

--
Kirk Brooks
San Francisco, CA
==3D==3D==3D==3D==3D==3D==3D==3D==3D==3D==3D=

Reply to this message

Summary created 6/3/14 at 5:02AM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com