>I have a program that generated a Cursor. I would now like to open a database and create a new table in the database with the same structure and indexes as the cursor. Then I would like to copy the data from the cursor into the new database table. Is there any commands out there that will aid me in doing this, instead of manually creating a table field by field.
>
>TIA.
You can use AFIELDS to create an array of the cursor info. Then use the CREATE TABLE FROM ARRAY command. Then APPEND FROM for the data. The indexes, AFAIK, you have to do manually, but there is the ATAGINFO() function that will create an array with the info you need.
UPDATE:
Try:
COPY TO TableName DATABASE MyDBC with CDX
Mark McCasland
Midlothian, TX USA