error with Adir()

[sqlpro]

Hi friends

i am getting an error with following command

lntot=ADIR(x,'\\ben\C\Vip_versions\tstnzgp\doc\*.*')

error is
Invalid subscript reference

actually abv folder contains around 14000 files.
is there any workaround for this?
Thanks


cheers

 

[danceman]

have you tried the maped frive letter to this UNC?

Attitude is Everything

 

[sqlpro]

Hi danceman
Thanks for the post.
No i did not try mapped drive.

actually i'm think the problem is with no of files.
if the folder contains only 10000 files then abv command
works perfectly if it exceeds 12000 then i get abv error.
i am wondering how to get around that

cheers

 

[danceman]

try not using the *.* to restrict the number of files. creat two arrarys and then combine them afterwards.

Attitude is Everything

 

[sqlpro]

actually i thought of that.
what if i dont know the extension of files that exist in
the folder?
how can i specify that i want only first 10,000 files then
next 10,000 like that...
Thanks for ideas

cheers

 

[danceman]

It may not be a foxpro problem. I do not remember the numbers, but depending on the version of windows you are running there are limits on the number of files that can exist in a folder safely. this could be why you can not get your results. try searching microsoft knowledge base.

Attitude is Everything

 

[craigsboyd]

sqlpro,

Have you tried using?

SYS(2000,'*.*')

SYS(2000,'*.*',1)

Put the second line in a loop and loop 10,000 times or until the function returns an empty string.

_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[sqlpro]

No Craig
i finally endedup taking files into a text file(using List())and creating a cursor from that text file.

cheers

 

[baltman]

ADIR() creates an array, which is limited (until VFP 9) to 65,000 elements. Each file has 5 elements, so the ADIR() will fail at around 13,000 files.

To get around this, use Windows Scripting faq184-4136

Brian

 

[sqlpro]

Thanks Brian
That is very useful link

cheers