>>>>>How do I programatically add a table to a dbc?
>>>>
>>>>Hi Albert,
>>>>
>>>>Look at the ADD TABLE command in the help file.
>>>
>>>Thanks, thought I looked for that... oh well.
>>>
>>>Incidentally, the help file says that you can use the array created by afields() for a create table XXXX from array aaaa. This does not work. It says that the table already exists. The name of the table used to generate the array is stored in array[1,12]. If that array element is replaced with the new table name, create table works. This would imply that the table name is not necessary for the create table command, but this generates a syntax error.
>>
>>Hi Albert,
>>
>>This does and doesn't work. It does work with a free table. It doesn't with a table connected with a DBC.
>
>Explain? I VFP6.0 the table is appearing in the dbc. The following code works:-snip-

Sorry, Albert, I didn't explain myself too clearly. Without making the replacement that you showed in the code it doesn't work if the table is connected with a DBC. With a free table, no replacement is necessary.