Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying records from one table to another having same na
Message
De
15/04/2001 07:10:50
 
 
À
15/04/2001 06:55:17
Ramachandran Duraiswami
C.G.International Pvt. Ltd.
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00495626
Message ID:
00495627
Vues:
15
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform