Number of Global fields in FMP

[darrel]

Hi All,

This will be probably be an easy one for all you FMP experts!!

I have a database with quite a number of one off values and I am using global fields for storing this data. Is there a limit to the number of Global fields you can have in FMP ? .... In fact is there a limit to the number of fields in one record?

Cheers

Darrel

[LiveOak]

There probably is, but it is VERY large. Practical considerations will probably make you solution unusable long before you exceed this limit.

If your solution is to be multi-user, don't use global fields to store your values. Globals in a multi-user environment reset to the values in place when the file was last opened in single user mode with FM (not server). The proper way to store these values is to create a separate "preference" file with exactly one record, set these values in text or number fields (not global fields), and access these values via a relationship from your other files.

-bd

[darrel]

Thanks for the info

My database is single user only so I should be ok with the globals - even if there is approximately a hundred of them (mainly used to hold temporary data when copying from one record to the next).

Cheers

[Vaughan]

Temporary data (variables) is fine for global fields. Static or persistent data should be in aprefs file as LiveOak suggests. I've been steadily converting all my solutions to use a prefs file, even the single-user solutions. It's so much easier. And reliable.