How to set Repeating Field to empty

[xoomaster]

Okay, this is crazy !

For the life of me I can't remember how to set a Repeating field and all to Empty ??

Set field ( Repeating_Field [0...1000] ; "" ) ??

What vale is used in the Repetition number ?

There is a easy way to do this other than looping ?

Xoomaster

[Søren Dyhr]

Two script steps:

Go To Related Record (Found Set)

Delete All Records

--sd

[Genx]

Yeah, I suppose the question comes to mind, what is it that you are storing in repeating fields in the first place?

[Søren Dyhr]

What are the odds... between healthy and unhealthy deployment??

--sd

[comment]

Seems a bit too drastic... Repeating fields are not rats - there's no need to call the exterminator at the first sight of them.

Actually, looping is quite easy (v.8 and higher). Or you could isolate the record and perform a re-lookup from a related repeating field holding the initial values.

Edited June 16, 2007 by Guest

[LaRetta]

Repeating fields are not rats - there's no need to call the exterminator at the first sight of them.

:jester:

[xoomaster]

Everything has its place !

I am incorporating tabs to my navigation module and using a repeating field to hold the active tabs.

Of course there are other ways of doing it, but using repeating fields is the easiest option in this case :P

[Søren Dyhr]

I've never in my wildest dreams ever though of fitting 1000 tabs into one layout... It's not angry fruit salat as David Kachel call's it but angry Tab salat!

But in order to pull the right tab just put a variable, which of the repetitions the Go To Field is stored on the particular tab. The repeater as such need no value what so ever.

--sd

Edited June 17, 2007 by Guest

[Genx]

never in my wildest dreams

Lol you sound kinda like Willy Wonka there :P

[Søren Dyhr]

Alright I think what this is about, audit trails ...again must I exhibit my astonishment, every body else uses a straigh forward text field which is pretty easily cleared:

Set Field[something; ""]

You could then have a calc'field (repeating) which splits each line into each it's own repeater:

MiddleValue(Extend(something);Get(RepetitionCalculation))

...if vanity dictates??? However have I made a tiny template that tracks in which of the tabs a particular field is modified, if say it's occuring in several tabs...

Feel free to tear the log into atomic details shown in a unstored repeating calc...

--sd

tabLogging.zip

Edited June 17, 2007 by Guest

[xoomaster]

Again, Why would I consider doing it that way when a 2 line of codes is doing the trick !

Trust me, It has been working flowlessly for 6 years now, I have no intention of using variables to fill the memory stack after a half a day of use !

:P

[Søren Dyhr]

I have no intention of using variables to fill the memory stack after a half a day of use !

Come again, I'm changing the same variable, not even behind the scenes would I expect much recursiveness going on ...do you have this right from the engineers mouth or what??

It's some times since the last complaints about memory leaks/ stack overflows have been posted - (fm5.5 or )!

But it's as usual my imagination that fails on me, could you post a template that shows what you're on about?? Since I get suspicious when ever people would do something to repeaters hiding the actual deployment from the audience, which hardly is catered for in relational theory.

Daniele have provided us with a scripted/CF combo, that prevents fireing blanks when looping thru each repetition. But it's a bad habit just to use the nearest fix at hand if the entire construction is a giant on clayfeet ...translated to filemaker; a flat'ish relational structure or rather the lack of structure.

http://www.briandunning.com/cf/472

Now it's indeed recursive, and might hog memory while fired!

--sd

Edited June 17, 2007 by Guest

[xoomaster]

I can't but start laghing

Since I have not much to do, I try to explain this one more time

The way I have designed my Navigation module, I need a holder for my active tabs once a tab or I should say a Layout is changed. Now I can use a single Text field to store tabs and their names and separate the values ( values from different layouts) by a marker, but this make it a longer developing time. Of cource I can use a variable and create them as I go on dynamically, but again it opens up my DB for other possible problems.

So simply, a reapeting field does the trick ! and by the way the example above [1...1000] was just an example, I am using onle 100 !

Why so emotions about repeating fields ? I have already had the pleasure of dealing with their limitations over years so I know where you are coming from.

Finally, just chill out dood : ) ha ha ha

Edited June 17, 2007 by Guest

[Søren Dyhr]

So simply, a reapeting field does the trick !

Perhaps, but the clearing of say just 100 reps. isn't done in one swell swoop, since the way repeaters works as relational keys have changed with fm7's introduction, making this method:

http://www.datatude.net/Demos/ClearAllReps.sit

...a bygone! The work with repeaters have been troubled in some direction and eased in other, you task needs to be a scripted one!

--sd

[xoomaster]

I agree with you though. The less you use Repeating fields the better off you are.

After 8 h of scripting, finally my Navigation module is able to handle Tabs. I hope FMP staff have plan of introducing:

"Get ( which tab(s) are really the front most out of multiple embided tabs)" !

Thank you.

I hope I did't offend you. I was just having fun with you.

Xoomaster :P

Edited June 17, 2007 by Guest

[comment]

I hope FMP staff have plan of introducing:

"Get ( which tab(s) are really the front most out of multiple embided tabs)" !

http://www.briandunning.com/cf/692

[xoomaster]

The problem with the above is that one can find all the front tabs , but the arrangment meaning keeping going back to the way the layout was is unpredectable ? All the methods I have tried so far gives you the individual front tab name, but it is difficult to know which one has the "Focus" when a layout is left ?

I hope this make sense !

[comment]

I haven't investigated this in depth, but wouldn't testing for 'hasFocus' be about the same as testing for 'isFrontTabPanel'?

[xoomaster]

I have not had much luck with that. Beside "Has Focus" the mouse has to be over the object when the script is running .

I think filemaker staff will introduce further functions in version 9, hopfully.

Edited June 19, 2007 by Guest

[comment]

Beside "Has Focus" the mouse has to be over the object when the script is running

I don't think that is correct. First, the only way I know of for a tab panel to get focus is by tabbing into it. If you then click a button to run a script, the focus is still on the tab panel.

But we have drifted off topic. Ultimately, tab panels are attributes of a layout, not a record. Any attempts to get around that are going to meet with difficulties.