Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Crash System on Duplicate Alias...
Message
De
09/08/2000 21:29:24
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Crash System on Duplicate Alias...
Divers
Thread ID:
00403211
Message ID:
00403211
Vues:
42
Our sales asking me to print a Quote Sheet of a Old VFP system
(Last Version of my Application)

As the Table Structure of new system is different from the Old one,
I don't re-compile a new executable file for her.

Thus, I try to make a Cursor with Same Name of Original Report View Alias

For Example:

Use MySales!NormOrders in 0 Alias NormTmp
Select 0
Select * From NormTmp Order by AnotherField Into Cursor NormOrders

The system will crash at the last line of code...

So, I need to do:

Use MySales!NormOrders in 0 Alias NormTmp
Select 0
Select * From NormTmp Order by AnotherField Into Cursor NormTmp2
Use IN NormTmp && Close the Original View Alias
Select * From NormTmp2 Into Cursor NormOrders

Then, it works well, and the report printing order is the correct one!! hehe..

p.s. I am using VFP 5.0 so that I can Select-SQL from another Cursor!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Répondre
Fil
Voir

Click here to load this message in the networking platform