open all tables in a directory

[choppysuey]

Hey everyone, I was interested in getting some sample code on how to get VFP6 to loop through and open all dbf files in a directory like 'c:\vfptables'. Currently I have the table names in an array and loop through that to open the tables I need. I think this is the hard way of doing it.

-suey

 

[Mike Lewis]

Suey,

Currently I have the table names in an array and loop through that to open the tables I need. I think this is the hard way of doing it.

On the contrary. That seems to me to be the easiest way of doing it. In other words:

- Use ADIR() to get the list of files

- Loop through ADIR, using each table in turn.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[mkrausnick]

Using an array is probably the most efficient method of processing a list of tables. I use that method all the time. If the list of files is not static, you can use the ADIR() function to populate the array.

Mike Krausnick
Dublin, California

 

[choppysuey]

Thanks guys for setting me straight. For some reason I had it in my head that there was an easier way in VFP then using the ADIR() function and t0hen doing the loop.

-suey

 

[ramani]

HI

You can lift the sample code from the following link..

http://winnersoft.coolfreepages.com/vfp/packdata.htm

The code is for packing all data files in a given directory. You can modify to suit your requirement.



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/