Beware of the IsEmpty function in 4.1

[charper]

I have verfied that my file size expansion problem described in my post below was due to an IsEmpty function I was using in a script that I had running automatically whenever my file was closed. When I replaced the IsEmpty function with an IF statement, the problem finally went away and has never been seen since. Go figure.

This was a pretty big deal because it could have resulted in my file size increasing by about 1mb every week (in addition to other natural increases). In two or three years it could have grown to over a 1gb and this system could be so complex by then that I may never have gotten to the bottom of this problem. Praise the lord.

[Vaughan]

IsEmpty and IF perform *completely* different tasks.

Could you post the offending command.script so I can take a look at it. Thanks.

[charper]

Sorry that wasn't clear. What I should have said was I replaced the IsEmpty function with and compare statement:

The offending script:

Setfield ["fieldX", case (

not(IsEmpty("fieldA"), "text1",

not(IsEmpty("fieldB"), "text2",

not(IsEmpty("fieldC"), "text3","text4")]

I replaced this with:

Setfield ["fieldX, case(

fieldA>"", "text1"

fieldB>"", "text2"

fieldC>"", "text3", "text4")

and my file size problem dissappeared for good! Neato. Any idea what filemaker thinks its doing with this IsEmpty function? Doesn't seem kosher.

[Vaughan]

Hmmm. I think that something else is going on here. What else does the script do? What other scripts run?