Report stored in memo fields of another dbf

[newfoxpro3]

Hello,

I have taken over a program where the previous developer has stored reports(FRX, FRT) inside 2 seperate MEMO fields of another dbf table. I need to modify the report and I am unsure how to extract them?

 

[Mike Lewis]

Try this:

1. USE the table in question.

2. Navigate to the record containing the report. (For example, use BROWSE.)

3. Execute this:

STRTOFILE(Memo1, "MyReport.FRX")
STRTOFILE(Memo2, "MyReport.FRT")

where Memo1 and Memo2 are the names of the fields holding the FRX and FRT respectively.

4. You now have a report file named MyReport. Go ahead and modify it, and save it when finished.

5. To get the report back into the memo fields, nagivate again to the record in question, and do this:

REPLACE Memo1 WITH FILETOSTR("MyReport.FRX")
REPLACE Memo2 WITH FILETOSTR("MyReport.FRT")

I think that should do the trick.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business