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
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