>Can a cursoe be indexed in fox 5.0? If so, how?
>
>Thanks in advance.
>
>Bob Andrson
Certainly. You just use INDEX ON ... like with a table.
If the cursor is read-only (i.e. generated with SELECT - SQL), you can only create one tag. However, you can make a read-write version with USE MyCursor ALIAS MyNewCursorAlias AGAIN IN 0 as long as your SELECT - SQL included the NOFILTER clause.
Also, if the cursor is the result of SELECT - SQL, make as full use of the ORDER BY clause as you can. It is often simpler and more powerful to do that than to index afterwards.
If you created the cursor with CREATE CURSOR, indexing is the same as with a table.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
