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