>Cetin,
>
>Carlos is encountering the problem that I am referring to, VFP is caching the temproary fiel at the time he is trying to open it again. I still repeat that USE AGAIN is a very poor way to create a writable cursor. It is dependant on a nuance of Fox that is not documented and therefore may not always work.
>
>If one need the result of a SELECT command to be updatable and modifiable, then select into table or use a view. I can't imagine when I would ever need to ALTER TABLE on something created with SELECT as you can create whatever you need in the SELECT command.
>
>Your testing is what I see also, but I still am not going to bet my clients applications of an undocumented nuance when the documented syntax to accomplish the same result is present.
Jim,
I can't understand what is undocumented. NOFILTER is documented as an "enhancement" and also USE AGAIN, DBF() etc are documented before.
I need "alter table" sometimes when I find it easier to code than coding directly in SQL. That is a matter of which I find easier. Creating an updatable SQL couldn't be done with shorter coding at all times and not supported in older versions (as alter table not supported too).
You could of course select into a table or use view. As someone said "In Fox you could do something in at least 3 ways or never". It's a preference and I would bet my clients w/o any fear.
You're true at what you're saying and also Carlos is.
BTW w/o use again you can still say it exists on disk with a fcreate or fopen trial.
Cetin