Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Loss of memo field in temp files
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement