>I wish to create a temporary empty cursor structure based on an existing table using SELECT * FROM MyTable INTO CURSOR MyCursor READWRITE WHERE .F.. Is the WHERE expression evaluated for every record? MyTable.dbf is very large (over 2 million records) and I am concerned this may affect performance.
>
>Any help would be appreciated.
>
>Alan
COPY STRUCTURE is specifically designed to copy only the structure, no records.
I think a COPY STRUCTURE should be much faster, in this case. But you will have to test whether there actually is a speed difference.
I believe COPY STRUCTURE only works for tables, so you would have to copy into a table first, and then to a cursor, in a second step.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)