Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writing to .frx as table
Message
From
03/09/1998 23:22:59
 
 
To
03/09/1998 22:32:33
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00132700
Message ID:
00133098
Views:
13
>>>>>I am using a printer driver that stores the # of copies in the expr memo field of the report .frx. I wrote a routine to change the copies=# entry in this memo. It worked fine during debug in foxpro but after compiling it will not let me write to the .frx - Does anyone know how to access and write to this memo field when running as .exe.
>>>>>
>>>>>thanks,
>>>>>David Martin
>>>>
>>>>When you build the .exe file, the frx is embeded internally, so it becomes read-only. That´s why you can´t write to it. You can retire the frx from the project and provide it besides the .exe file; this make the program work while still being able to write to the memo.
>>>
>>>Thanks for the response. When you say retire the .frx; does that mean I uncheck the report in the project info. and rebuild the .exe?
>>>
>>Hi Dave,
>>
>>Simply mark the report as excluded. That way you can still access it through the project manager. You will, however, have to provide it along with the exe.
>>
>>hth,
>
>Worked like a champ. Thanks for the help.
>
>Dave

David,

Another idea. Since it is cleaner to include the report in the exe, you can make a copy of the frx/frt file into a temporary table, modify it the way you want to, and the run the new, temporary report.

lcTemp = SYS(3)
SELECT * FROM ReportName INTO TABLE (lcTemp)
REPLACE ...
USE
REPORT FORM (lctemp+'.dbf')
DELETE FILE (lcTemp+'.dbf')
DELETE FILE (lcTemp+'.fpt')

I tried using a cursor, but it must be closed before running the report is run, and then it disappears.

Alex
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform