>can you create a cursor with an alias so that use can refer to itby an alias name like: "sele thisalias"

Hi Tim,

If you create using CREATE CURSOR, the name you give it is the alias, i.e. in

CREATE CURSOR MyCursor . . .

"MyCursor" is the alias

If you create it using a SELECT statement, you assign it the alias name in the statement, i.e. in

SELECT * FROM MyTable INTO CURSOR MyCursor NOFILTER

"MyCursor" is the alias
( NOFILTER forces creation of actual cursor, not a filter on original table )

If you want, you can use it again with another alias, i.e.

USE DBF( "MyCursor" ) IN 0 AGAIN ALIAS MySecondCursor

Bill