Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crash System on Duplicate Alias...
Message
From
09/08/2000 21:29:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Crash System on Duplicate Alias...
Miscellaneous
Thread ID:
00403211
Message ID:
00403211
Views:
41
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.
Reply
Map
View

Click here to load this message in the networking platform