Oops...I didn't notice that you weren't using CREATE TABLE.

CREATE gives an error of the table you are trying to create already exists in a database. It does seem to support this syntax (although undocumented, as far as I see).



>Hi Steve,
>
>Interesting. This command was originally written by my colleague and it worked just fine. However, I'm trying to find it in Help, and I can't. All I found is CREATE TABLE command with the array syntax. Well, it would be a really bad problem and I need to re-write this program...
>
>>Nadya,
>>
>>This syntax creates a table from an array. I don't think you can use this syntax for creating a table from another table structure stored in a dbf. I think you should get an error message.
>>
>>
>>>Hi everybody,
>>>
>>>I think, I'm going crazy. Here is the code
>>>

create (m.lcNewBldMstr+'_B') database (m.lcNewBldMstrName) from (m.ltBldMstr)

>>>
>>>ltBldMstr is a temp table (created by copy structure extended command)
>>>
>>>I was stepping through this code in debugger and this line was executed. So, in my opinion, the new blank table should be created. However, the table is full of records, which are leftover from the previous run. I ran this code several times and always table contained records. What could be wrong here?
>>>
>>>Of course, I can delete the whole database and recreate this table in a code, but why this line doesn't do, what I'm thinking, it should do?
>>>
>>>Thanks in advance for saving me from insanity...