>>>
>>>close table all
>>>close database all
>>>FREE TABLE resolutions
>>>
>>
>>Doing that and trying to add it back, gives an error "Table resolutions already exists in the database"...
>
>I am afraid, we are talking about different things. I answered the question assuming there is no table in the database because you could not add the table to the database using create .. from array command.
>If the table exists in the database, then use remove table command.
>
>As of why create ... from array does not work, then you probably already understand that with afield() you create an array having long name of the table (array column 12). Thus, with the create .. from array you attempt to create another table having the very same long name. And it is not allowed.
>But with COPY command you cretae the free table and you may then add it to database.
COPY TO command not only creates a table but it may also add it to a database.
Edward Pikman
Independent Consultant