>>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
>><>
>
>Working with imaging applications, I found that it's reasonable to move all images into separate table with two fields ID (I) and General (for images). ID provides link to master table. Now the maintenance (e.g. change/delete images) means actually deleting old records and inserting (if necessary) new one, and PACK MEMO on this separate table will squeeze fpt file.

That's what I was a fraid of. If I am able to get the file exclusively after I update the images I issue a pack. I'll try breaking the images out into a separate file and do something like a set relation to the master departmt file.

Thanx

Fred Lauckner

Fred Lauckner

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

.Net aint so bad.