Indexing Problem

[FoxEgg]

I want to create a database of 'unique' values from a larger one 61,000 records.

I did this.... by

inde on lastname+file_num to lastname UNIQUE

then did

COPY TO ARRAY XYZ

then opened a new table with thre same structure

then did

APPE from ARRAY XYZ

it copied only the first 1000 records then stopped... (got to about the B's)

(I even tried it in FPD and got a too many files open error. Config.nt has 255 files and buffers set).

Am I missing something ?
Is there a glitch in W2000 ?

John Fox
Oz

 

[imronh]

try this
-----------------------------
*** This will transfer unlimited number of unique records:
index on lastname+file_num to lastname UNIQUE
COPY TO TEMP
use <newDBF>
APPEND FROM TEMP

------------------------------
You used an array which has memory constraints. Maybe you found the limit.

 

[FoxEgg]

That was quick reply... I only had time for a shower.
I'll try it later... Thanks.

 

[FoxEgg]

It worked like a charm !!!!

I must learn to shower more often....

I presume there must be a memory limit with COPY TO ARRAY

Many thanks

John Fox

 

[rgbean]

John,
The explanation for why the Array method doesn't work, is because you can only have 65,000 elements in any array. I'm guessing you have 64 fields in your table? (The 65th is the delete flag!)

Rick

 

[FoxEgg]

Thanks for the explaination Rick.... and thanks to Ron for solving my problem....

John