COPY STRUCTURE EXTENDED and CREATE FROM:

syntax for the CREATE FROM command shows that you can include a database to add the table to. I tried to do this, due to having some longer field names in the table I am creating.

Heres the picture:

I created tables on the fly that have the same structure as you get with a COPY STRUCTURE EXTENDED command. They are part of a data driven system I am developing to flexibly handle our need to import and export files in a variety of formats in our application. I made a form that allows user entry of a file format, as in field name, field type, size, dec. These are stored as definitions for the formats we would need to either import or to export our data into and send to clients.

Then I use CREATE FROM, when I want to create an instance of a defined file format, import to it, and do other processing.

In any case, the command allowing yo to add the created table to a database leads to:
".DBC Internal consistency error."

The command looks like this. It is executed from the folder containing the 'extended' file (in this case - cpmpbg.dbf)

If I could use short field names this would not matter, but this big nasty one I am working on has like 120 separate fields, with similar names.

CREATE cpmrawpbg database test from cpmpbg