Jump to content

Clear entire repeating field quickly, FM8

This topic is 5658 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is there a way to quickly clear an entire global repeating field that does not require each repetition to be deleted?

I am currently implementing a set of back/forward buttons in a database using a global repeating field of an arbitrarily large size. Since these type of buttons act as a stack, I tried to implement the functionality as one would normally use via an array (i.e each new page visit yields a push on the back stack, clicking back pops the value off back and pushes in onto the forward stack). Since FM8 supports accessing individual elements of a repeating field dynamically (I have done this in previous versions of Filemaker via string operations), using a repeating field seemed like the most 'natural' solution. However, I want to clear the global repeating fields upon file exit (or open) without having to loop through each element. Moreover, when ever a new page is visited the forward stack needs to be cleared. Currently, I can avoid having to clear the entire stack by creating another global variable to essentially act as a pointer to the location of the proper index to access. However, I do not want additional data being stored in global variables where not necessary. (In a quick test I did, storing a floating point number in each of the maximum possible 32000 repetitions resulted in about a megabyte of storage.)

So, how can I clear a repeating field quickly?

Link to comment
Share on other sites

This topic is 5658 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.