Hi Mat,
CREATE ... FROM ARRAY needs a special array
from Help:
FROM ARRAY ArrayName
Specifies the name of an existing array whose contents are the name, type, precision, and scale for each field in the temporary table. You can use the FROM ARRAY clause instead of specifying individual fields. For the proper format of the contents of the array, see AFIELDS( ) Function.
So You need to create the cursor acording to the fieldstructure of ADIR() and APPEND FROM ARRAY
HTH
Agnes
>Hi:
>
>I've never used ADIR() nor arrays. I'm trying to get files names from a network directory (mapped as Z:\) into a VFP cursor. This is what I've tried so far:
>
>SET PATH TO Z:\
>filecount = ADIR(existingfiles,'*.MPG')
>
>? filecount will display 24110
>DISPLAY MEMEORY existingfiles will displays all of the file information.
>
>Now, I'd like to get this information from array 'existingfiles' into a VFP cursor by doing the following:
>
>CREATE CURSOR filedata FROM ARRAY existingfiles
>
>This produces a "Array dimensions are invalid" error message.
>
>What am I missing.
>
>TIA
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]