>please help me understand the use again statement.
>
>use out
>select * from out into cursor temp where out_pk = 1001
>
>select temp
>browse
>* temp has one record
>
>USE DBF('temp') AGAIN IN 0 ALIAS temp2
>select temp2
>browse
>* temp2 has all the records in out
>
>replace out_pk with 1002
>
>*not only does it change the record in temp2 but it changes the record in out
>
>what if you don't want the changes to reflect in the out table, you only want to modify the cursor. do you have to use the create cursor statement.
That means not only that "use again" on a filtered cursor gives you a read/write cursor which is a filter on the original table, but that it actually behaves as an updateable view... which would be a nice shortcut, if we could rely on it. Since Fox decides when it will be a filtered cursor (unless we put NoFilter in select, we never know if it will be filtered or not), we can't.