>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
usedbf("myCursor") againin0alias 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