Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create table command doesn't do anything
Message
From
27/11/2001 13:57:15
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00586484
Message ID:
00586500
Views:
12
This message has been marked as a message which has helped to the initial question of the thread.
Another thought...

Why do you bother with the COPY STRUCTURE EXTENDED step? You can cut straight to the chase and get a new table with no records:
copy to (m.lcNewBldMstr+'_B') database (m.lcNewBldMstrName) for .f.
>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...
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform