Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: bryan wetton
  Where is bryan wetton?
 Morphett Vale
 Australia
 bryan wetton
 Tags
Subject: Confusion with parameters and OPEN
Thread ID: 209211 Message ID: 209211 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Friday, December 26, 2008 12:38:45 AM         
   


I am attempting to use a routine offered elsewhere here by Andy K.

I want to generalise that routine to process a number of tables to copy into new ones. All relevant table names are stored in a table.

In a loop I am passing parameters to the routine thus :-

myoldfile = eg 'sample_$' - obtained from my list
mynewfile = eg 'TEMP_LL' - obtained from my list
myoldfull = the full path of myoldfile from an adir()

Parameters myoldfile,mynewfile,myoldfull

If File( myoldfull)

	newpath=Justpath(myoldfull)

	Set Default To (newpath)

	USE  myoldfile In 0



I have tried many variations of the USE command eg with myoldfull and no changing of default folder.

What am I missing?


-Bryan



COMPLETE THREAD
Confusion with parameters and OPEN Posted by bryan wetton @ 12/26/2008 12:38:45 AM
RE: Confusion with parameters and OPEN Posted by Andy Kramek @ 12/26/2008 2:25:11 AM
RE: Confusion with parameters and OPEN Posted by bryan wetton @ 12/26/2008 2:37:04 AM
RE: Confusion with parameters and OPEN Posted by Andy Kramek @ 12/26/2008 1:49:04 PM
RE: Confusion with parameters and OPEN Posted by bryan wetton @ 12/27/2008 2:32:06 AM
RE: Confusion with parameters and OPEN Posted by Andy Kramek @ 12/27/2008 4:05:04 AM
RE: Confusion with parameters and OPEN Posted by bryan wetton @ 12/27/2008 5:07:54 AM
RE: Confusion with parameters and OPEN Posted by Andy Kramek @ 12/27/2008 7:06:59 PM
RE: Confusion with parameters and OPEN Posted by bryan wetton @ 12/27/2008 11:04:24 PM