Newly added data is lost on file close

[diamondgirl]

I'm having a quirky problem with FM9: In one particular file: It's a file I use to print off barcoded labels, which are run incrementally in a series of 800. So we know which set was run last, we've made a message field that records the last number we printed, so we don't duplicate. On occasion (like with today's batch, I haven't printed these since 1-3-2008), everything functions correctly while I have the file open.

When I close the file and re-open, all data from today is gone and it reverts back to 1-3-2008 for my message and numbers. Why wouldn't it be saving any of the new data I'm putting in?

[bcooney]

Sounds like your message field is set for global storage. Any value in this field is lost when the file is closed. The field defaults to the value it had when last closed as single user.

[diamondgirl]

Yep--field was set for global storage. I copied all the data, then pasted into another file. I thought I'd uncheck the global storage box to see what happens. I pasted the old data in. That didn't fix it. (probably the wrong thing to do). I changed all the settings back, including adding global storage, pasted old text in, then ran the scripts. NOW, when I open the file, that entire field is empty--so it changed the data, now to a blank field!

If it's a context issue, how do I fix that? Do I take it off the server and use it as a desktop database?

[diamondgirl]

OK--I figured it out. When I took the file out of FMServer and opened it as a single user document, I was able to cut and paste (restore) all the data I deleted in my experiment above and my numbers advanced properly. Unless there's another way to do it, I guess I can't host this file as part of FMServer.

[Carri]

HI,

I was having a similar probelm with Global fields and someone brilliantly suggested to write a script that on file close copied all the values in the global fields to another field and on file open copied them back in. That way you can use on server.

[diamondgirl]

Nice! I'll have to try that one! Thanks!