Hilmar,
I myself handle it with a table.
>And what is the problem with a table?
Dimitris inital problem was a very very large table he did'nt wan't to duplicate.
>There isn't much difference between a cursor and a table, except for the following: A cursor is deleted automatically when you close it. A table is not - if you don't want it any more, you have to delete it manually. You want the latter!
Don't forget CDX at cleanup.
>Of course, there is another important difference. With a cursor, VFP creates a temp table name, and assigns the alias you specify. But this, too, you can control yourself. Just use sys(2015) to create the table name.
BTW
Hate this sys(2015). Everytime it crashes, I just see cryptic names. Have automated complex rekursive integrety checks controled by metadata over my tables where I crossed the same SELECT ... INTO n times. I prefer speaking names like Test_099 for test in 99th rekursion ...
Thank you for help
Agnes
>
>Hilmar.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]