Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying records from one table to another having same na
Message
From
15/04/2001 07:10:50
 
 
To
15/04/2001 06:55:17
Ramachandran Duraiswami
C.G.International Pvt. Ltd.
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00495626
Message ID:
00495627
Views:
14
>hi there!!!
>I work in a firm where our program is dependant on the financial year. So, our tables are also stored in folders named
>after the ongoing financial year i.e., 2000-2001,2001-2002 etc. After the end of the last year, we had to carry over to
>the new year where all tables in the new folder were zapped. Now, a situation has arisen where I require some of my
>programs to take data from the current folder(2001-2002) as well as the previous folder(2000-2001). But the tables
>have the same name in both the folders. How do I accomplish this objective?


Just use the tables with an alias so that they are clearly identified:

USE \2000-2001\MyData ALIAS MyData00 IN 0
USE \2001-2002\MyData ALIAS MyData01 IN 0

You now have both tables in use, one with a reference alias MyData00, the other MyData01. Since they have unique aliases, they can both be open at the same time and dealt with distinctly.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform