I have a container field that I use to hold a company logo JPG. I can change it, delete it, delete the record , and it will come back, as tho there is a buffer somewhere that I cant find. Help
Is this perhaps a global container field located in a file hosted via FileMaker server or hosted from FileMaker Pro?
In that context, any change to a global field is unique to a given client user (other users can't see the change) and the change value reverts when the client closes the file.
If this is the case, you'll need to either:
a) take the file down off the server, modify the container field while opened directly via FileMaker and then put it back up on the server
b) change how you manage this container field's data by using either a cartesian join to a non-global container field or using a start up script that updates the global field from a non-global field each time that a client opens the file. (You then make permanent changes to the field's value by editing the non-global field used to update the field during start up.)
I appreciate the help,
I need it to be a Global field, as it is a company logo JPG, used on several forms and reports that are generated from the DB. I only did a "Insert Image" into the field, never did a off server file. When I delete it , delete the record , insert new image, it always revert to the old image. Where is this "buffer memory" file kept? Could I delete it from there?
This DB is hosted in the cloud, not sure how to do a server hosted file for the image.
Create a new table with only 1 record and only 1 container field, relate your original table to it via a cartesian relationship, put in your starting script a set field that sets the global to the image in the 1 record table.
Until you're able to unload the database and kill the value in your global logo there's not much else you can do methinks.
If you are using FM Cloud, them your file is indeed hosted from a server and my comments apply. The location from which you insert the file makes no difference here.
siplus and I are giving you the same advice.
Use a non-local container field to store your logo. Then use either a Cartesian relationship (x operator instead of =) to make it accessible throughout your solution or set up a script that copies the value of this field to your original global field when the file first opens for the client. In File Setup, you can select the OnFirstWindowOpen trigger to perform such a script. Then, to change the field, you edit the nonglobal copy rather than the global.
See here for more on the topic: https://support.filemaker.com/s/answerview?anum=000023019&language=en_US
Thanks for all the help., You guys pointed me in the direction I needed.
My solution :
I made a container field that is not a Global with the JPG in it.
Then a short script to run at OnWindow Open, to ReplaceFieldContents, to the Global field that is used on all the layouts.
and it works!!
Thanks again guys!!
Don't Use replace field contents. use set field instead.
Replace Field contents on a global field works, but if you did this on a non-global field, you could modify every record in the table with the specified value and with no undo to reverse it.
Retrieving data ...