Record Size & Container Field

[Greg Hains]

Hi there.

This question either has no answer or is so simple I will look foolish.

I have client with a Filemaker 7 database who records artwork in container fields. The database is now around 2GB in size yet there are not that many records.

Is there any way that I can determine the size of an image in a container field? I would have thought that the size if the displayed field may have had some bearing on it, but unsure.

I want to be able to flag fields with images that need reduction so we can trim the database down a bit.

Or... does FmPro not work like this with variable record sizes.

Enlighten me please.

Greg

[bcooney]

Have you considered using image references? Also, they should immediately upgrade from the much-troubled FM7.

[vladisglad]

i don't recall if FP7 has the length function but that's what you need to do.

Create a calculation field Length (containerfield)

This gives you size of the container field in bytes. Do Length(containerfield)/1024 for kilobytes

:(

[Greg Hains]

Thank you both. I will look into these options.

Cheers,

Greg