>>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
>
THANKS Bill
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."