Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Loss of memo field in temp files
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Loss of memo field in temp files
Divers
Thread ID:
00066314
Message ID:
00066314
Vues:
63
I have code (written by someone else) which does these things:

IF FILE("mydata.DBC")
DELETE FILE mydata.DBC
ENDIF
IF FILE("F1.DBF")
DELETE FILE F1.DBF
ENDIF
... same for a few more files
IF FILE("F1.FPT")
DELETE FILE F1.FPT
ENDIF
... same for a few more files
CREATE DATABASE mydata
USE olddata
COPY TO F5
ALTER TABLE F5 ADD COLUMN mysortfield C(35)
SELECT F5
REPLACE ALL mysortfield WITH myfunction(afield, anotherfield, blah, blah2)
SORT TO F1 ON mysortfield FOR some conditions
SORT TO F2 ON mysortfield FOR some other conditions
ADD TABLE F1
ADD TABLE F2
GOTO TOP
CLOSE TABLES ALL
CLOSE DATABASES ALL
OPEN DATABASE mydata
SET DELETED OFF
USE F1 IN 0 ALIAS F1
USE F2 IN 0 ALIAS F2
SELECT F2
RECALL ALL
SELECT F1
INDEX ON field1 TO I1
SELECT F2
INDEX ON field1 TO I2

When I USE F1 later and run a report off it, the memo field is not recognized, although an F1.FPT, F2.FPT, AND F5.FPT are created. Is there something wrong with the way I have used these commands that would lose the memo field?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform