Hi all,

I've got a migration problem when I moved on to FM 8.5.

My situation in short:
I have reports with text and images. Images are referenced from
calculated results and represented in container fields. Works great! If
I get an error message (The file cannot be found: "filename.jpg"), it
is written in an invisible color in the container field so it doesn't
show in the report. Same with borders: by default, no borders are shown
for the fields.

But now, in version 8.5, I run in to a problem. Whenever I get an error
message as above when an image is not available, the border of the
container field is non-suppressable (I can edit the behaviour of the
border but it doesn't help!) and shows with bold borders in reports.
The text in the container field can be suppressed (by using white font
color).

Has anybody gotten a solution to help me out? I've tried some tricks,
see below.

I've worked on several solutions to find all containers that contain
errors / no images so I can delete all contents. Íf I get this, a
normal container field is left and this field acts normal and doesn't
show a bold border.

1) Get (LastError): doesn't work because a calculated reference doesn't
result in an error. Just showing the image does and that is not a
script step on which LastError can report.
2) GetAsText (container): doesn't work because the calculated reference
of the filename is returned, not the error text.

Please help me out!

Harry

Harry,

As far as I'm aware there is no known solution. Write to those FileMaker
guys at filemaker.com, as I have done. I have searched for a solutions and
so have others, but found nothing.

Ursus

"Harry" <harry104 (AT) zonnet (DOT) nl> schreef in bericht
news:1164390855.247667.320460 (AT) 45g2000cws (DOT) googlegroups.com...
Hi all,

I've got a migration problem when I moved on to FM 8.5.

My situation in short:
I have reports with text and images. Images are referenced from
calculated results and represented in container fields. Works great! If
I get an error message (The file cannot be found: "filename.jpg"), it
is written in an invisible color in the container field so it doesn't
show in the report. Same with borders: by default, no borders are shown
for the fields.

But now, in version 8.5, I run in to a problem. Whenever I get an error
message as above when an image is not available, the border of the
container field is non-suppressable (I can edit the behaviour of the
border but it doesn't help!) and shows with bold borders in reports.
The text in the container field can be suppressed (by using white font
color).

Has anybody gotten a solution to help me out? I've tried some tricks,
see below.

I've worked on several solutions to find all containers that contain
errors / no images so I can delete all contents. Íf I get this, a
normal container field is left and this field acts normal and doesn't
show a bold border.

1) Get (LastError): doesn't work because a calculated reference doesn't
result in an error. Just showing the image does and that is not a
script step on which LastError can report.
2) GetAsText (container): doesn't work because the calculated reference
of the filename is returned, not the error text.

Please help me out!

Harry

Sure there is a solution.

You can test for the presence of the file by attempting to "re-import" the
reference. Here is an example script:

Set Error Capture [On]
Set Variable [#imagepath; Value:GetValue(YourTable::YourContainerField; 3)]
Go to Field [YourTable::YourContainerField]
Insert Picture [Reference; "$imagepath"]
Show Custom Dialog ["Result"; Get ( LastError )]

If the file exists, you will have a result of 0. If it is missing, you will
get a result of 100.

"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote

I used (FMP6) to create a new calc field = Case(YrTable::Image > 0; "X"; "")
which has an 'X' if there is an image to show and nothing if not. I suppose
it works the same way in FM7-8.
I don't know if this could be of any help for you.
Remi-Noel


"Harry" <harry104 (AT) zonnet (DOT) nl> a écrit dans le message de news:
1164390855.247667.320460 (AT) 45g200...oglegroups.com...
Hi all,

I've got a migration problem when I moved on to FM 8.5.

My situation in short:
I have reports with text and images. Images are referenced from
calculated results and represented in container fields. Works great! If
I get an error message (The file cannot be found: "filename.jpg"), it
is written in an invisible color in the container field so it doesn't
show in the report. Same with borders: by default, no borders are shown
for the fields.

But now, in version 8.5, I run in to a problem. Whenever I get an error
message as above when an image is not available, the border of the
container field is non-suppressable (I can edit the behaviour of the
border but it doesn't help!) and shows with bold borders in reports.
The text in the container field can be suppressed (by using white font
color).

Has anybody gotten a solution to help me out? I've tried some tricks,
see below.

I've worked on several solutions to find all containers that contain
errors / no images so I can delete all contents. Íf I get this, a
normal container field is left and this field acts normal and doesn't
show a bold border.

1) Get (LastError): doesn't work because a calculated reference doesn't
result in an error. Just showing the image does and that is not a
script step on which LastError can report.
2) GetAsText (container): doesn't work because the calculated reference
of the filename is returned, not the error text.

Please help me out!

Harry

Doesn't work that way in FileMaker 7/8.

"Remi-Noel Menegaux" <rnmenegaux_AT_free.fr> wrote

Bill

My reaction to Harry, was regarding his problem with borders around empty
containerfields. Which was his question. It was not with a problem testing
for valid picture references. Sorry if that was unclear.

Ursus


"Bill Marriott" <wjm (AT) wjm (DOT) org> schreef in bericht
news:dJCdnbjTR9r9HfXYnZ2dnUVZ_oednZ2d (AT) comcast (DOT) com...

Bill,
As I was a bit surprised with your - short - reply, I tried to convert in
FM8.5 one single file I had in FMP6 to hold - and show - the reference to
images file with extension '.jpg'.
(I just dropped down my FMP6 file into the FM8 icon)
And it worked !
My calculated field is NotEmptyImage = Case(not IsEmpty(Image); "X"; "")
If I search on 'X' I find the records with a valid image and if I search on
'=' I find the records with no image.
To clarify, I then made NotEmptyImage#2 = Case(YrTable::Image > 0; "X"; "")
And this does NOT work, as you said.
So once again you are right, which is normal to me, coming from you...
Anyhow, maybe my 'solution' above is an alternate solution to what was
requested.
Remi-Noel


"Bill Marriott" <wjm (AT) wjm (DOT) org> a écrit dans le message de news:
R-Wdnebv2OnNCvXYnZ2dnUVZ_s6dnZ2d (AT) comcast (DOT) com...

Bill, I'm not completely new to FM but I can't figure out your script
proposal...

I can't find the 'Set Variable' command, neither 'GetValue'

I can only store a fixed Reference;

Further, what do you mean with the # and $ signs?

I assume that I can enter an IF statement here to suppres the error and
do something to prevent my problem...

Thanks! Harry

Harry wrote:
Bill,

I was not yet very sharp this morning... I opened FM7 instead of FM8.5!
Your script proposal works perfectly. I'll start working on an If /
else routine to fill my container values if Get(LastError) returns 0 /
100.

Thanks again,

Harry

All, thank you for your help! I'm back on track again thanks to your
quick suggestions.

Take care,

Harry