Visual FoxPro Programming - Changing alias

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Changing alias

Michael

2006-06-28, 7:07 pm

Is it possible to change the Alias of an existing Cursor? The point is
following:I have selected several data from tables into a cursor. Now I want
to select a subset of this
data into a Cursor again, but it has to replace the former Cursor including
the alias.
Example

SELECT * FROM sourcetable INTO CURSOR tempcur
..
..
..
SELECT * FROM tempcur INTO CURSOR tempcur1 ORDER BY .... WHERE ... and more

I want use this tempcur1 as tempcur.
The clauses in the 2nd SELECT-Statement result from User-Interaction

thanks in advance

mr

Christian Ehlscheid

2006-06-28, 7:07 pm

Hi,

SELECT * FROM tempcur INTO CURSOR tempcur ORDER BY .... WHERE ... and more

should work just fine .. the cursor will overwrite itself ..

Regards
Christian

Sponsored Links