Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Loss of memo field in temp files
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Loss of memo field in temp files
Miscellaneous
Thread ID:
00066314
Message ID:
00066314
Views:
65
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?
Next
Reply
Map
View

Click here to load this message in the networking platform