>>I have an application that generates statistical reports containing graphs. These are multi page reports so to place the graphs on the report I append them to general fields using the link parameter.
>>
>>APPEND GENERAL departmt.bmpw FROM &pcbmpw LINK
>>
>>What I need to do is to be able to break the link, clear out the contents of the general field if there is not a graphics file for this particular run. I can always filter the report, but the Memo file is going and even after a pack it is over 30 Megs. (only needs to be about 8 Meg) Not large, but causes a replication problem under Novell.
>>
>>Fred Lauckner
>>Paragon Engineering
>><>
>
>Fred,
>
>If you just want to clear out the general field, try the BLANK command.
>
>-Mike

Mike:

I've tried several ways. Doing a scatter memvar memo blank, setting the title and a couple of other fields and then doing a GATHER MEMVAR MEMO and the general fields are not closed out. What i'm going to do is to move the general field information out of the main table and create one record for each graph in temporary table. (Edward Pikman's suggestion) Then I can just do a set relation to get the information.

Thank you for your help.

Fred Lauckner
<>

Fred Lauckner

You know, it works on my computer. I don't know what your problem is.

.Net aint so bad.