Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use Of ADIR()
Message
From
12/06/2008 02:42:47
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
12/06/2008 02:37:47
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01323376
Message ID:
01323377
Views:
17
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.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform