>Guys,
>
>Hi,
>"
>>>>Also, rather that using AFIELDS, you could
>>>>SELECT * FROM tablename INTO CURSOR cursorname NOFILTER
>>>>to get a copy of your original table for reporting."
>
>This works fine but as someone pointed out it will bring all records of the
>existing table into a cursor
>
>>>
>>>You raise an interesting point here Mark. That sure is a way to create a cursor based on an existing structure. The cursor will contain every record in the original dataset. I often want an empty cursor.
>
>True.
>
>Another limitation that we have here is that whatever cursor we create from a SELECT statement will be read only which in my case wouldn't work, since I need to append an extra field for my reporting purposes (a memo field).
>
>>>Does anyone know a fast one liner for creating an empty cursor based on an existing structure?
>
>To add to this I'd say that should be updateable and modifiable as well whith such commands as ALTER TABLE and the rest
>
>Thanks,
>
>Gil

Gil, yes, you're absolutely right, I'd forgotten that as one of my requirements that it be read/write at least. Know I know why I still use AFIELDS(). Ability to Alter would certainly be nice, I fudge this by modifying the array before doing Create Cursor from Array.