Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating Tables
Message
De
15/09/1998 11:43:32
Bao Nguyen
Heritage Information Systems Inc.,
Richmond, Virginie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Creating Tables
Divers
Thread ID:
00136786
Message ID:
00136786
Vues:
68
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.

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform