Hi, Dore,
Man....Who Knew?

This works fine, however, I had to place the keyword AGAIN after the dbf name.

USE DBF(myfile)AGAIN ALIAS myname

Many thanks!


---- Larry


>>More anomalies?
>>
>>Is there any way to get the results of a SQL statment into an updatable cursor? We've noticed that if you use SELECT ..... INTO CURSOR, the resultant cursor is read only and can't be updated with INSERT or UPDATE statements.
>>
>>Cursors created with CREATE CURSOR behave just like tables and can be UPDATED, ALTERED, or INSERTED.
>>
>>The problem I'm trying to get beyond is the whole issue of temporary files when creating elaborate queries. Ideally, I'd like to use cursors instead of creating tables for queries requiring multiple intermediate steps.
>>
>>--- L
>Assume the cursor that is the result of your query is named "query". You can write to this cursor by issuing the following command:
>
>USE AGAIN DBF('query') ALIAS whatever