>Glad I could help.
>
>By the way, if you want to make a "writable" cursor (and therefore not worry about unique file names) you can do the following:
>
>SELECT INTO CURSOR mycursor
>LOCAL laFields[1]
>=AFIELDS(laFields)
>CREATE CURSOR writable FROM ARRAY laFields
>APPEND FROM DBF("mycursor")
>USE IN mycursor &&Close and erase
>

Hi Brad,

Actually, no need for these complications. Simple

use dbf("myCursor") again in 0 alias myWritableCursor

will do the trick.

>Of course, this assumes that the original SELECT truly *did* create a temporary file and that it wasn't just a filtered view of the original table (i.e. a fully-optimized query).
>
>Best...
>
>--Brad

If it's not broken, fix it until it is.


My Blog