Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Tables
Message
From
15/09/1998 11:43:32
Bao Nguyen
Heritage Information Systems Inc.,
Richmond, Virginia, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Creating Tables
Miscellaneous
Thread ID:
00136786
Message ID:
00136786
Views:
69
The environment:

My main program contains several create table like the one below.
gcBatchDbf = SUBSTR(SYS(2015), 3, 10)
CREATE TABLE &gcBatchDbf (Batch_ID c(8), Descript c(40), ;
m_Pat n(10), Num_Claim n(10), User_Name c(25), Date d(8))
USE
USE &gcBatchDbf ALIAS BatchTmp IN 0

The problem:

Sometimes this CREATE TABLE command will create an actual table as
part of a database container. When I delete the table, the name of
that table will still be in the database container but it's
not out there on disk.
The delete command I used is:

USE IN BatchTmp
DELETE FILE (gcBatchDbf) + ".Dbf"

The frequency for this to happen is only
around 10%.

The question:

Is there a way to create a table and then delete it without adding
it to the database container.

Next
Reply
Map
View

Click here to load this message in the networking platform