>I have a table and I would like to reproduce the structure of it in an SQL command and/or to create a cursor exactly like it.
>
>Is there a way I can do this?
The simplest way is COPY STRUCTURE which replicate structure to new empty table.
Also you can:
1. COPY STRUCTURE EXTENDED creating table containing current table structure info
2. modify this table content, if necessary
3. AFIELDS() to collect structure info into array
4. CREATE CURSOR FROM ARRAY ...
Edward Pikman
Independent Consultant