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
NormOrdersThe 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
NormTmp2Use IN NormTmp && Close the Original View Alias
Select * From NormTmp2 Into Cursor
NormOrdersThen, 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.