Looping Script

[Ben Ball]

I have a record that shows records through a portal via a self join.

I have the records shown by a condition of them being open.

I need help or some idea on a looping script that will go through the records shown (or each portal row) and give them all the same ID so I can reference all the items at that time later on.

I have no experience with looping at all. Can anyone help?

[Søren Dyhr]

I wonder if your solution needs to be multiuser or we can get foolish and careless about record locking?

If so, is all it takes a GTRR(SO) and this:

http://www.filemaker.com/help/Script-Steps51.html

--sd

[Ben Ball]

Hi, This has kind of guided me towards my solution below.

Enter Browse Mode

Go to Portal Row [select;first]

Loop

Set Field [Table::Field; Table::Field]

Set Field [Table::Field; "closed"]

Go to Portal Row [select;Next;Exit after last]

End Loop

Refresh Window

Thanks for popping in I say

Edited January 31, 2006 by Guest

[Ben Ball]

I also have another problem which relates to this and all of my other scipts that involve "Portal Rows"

I have scipts that run through portal rows, within a portal but the fields that I have set do not change until I click away from the portal.

i.e. the last portal row is still highlighted when the script is finished.

Is there any step that I can introduce in order to stop this. I have tried sending the script to a different field and tried refreshing the window but nothing seems to work??

Can any one help with this?

[Søren Dyhr]

Read on McDuff:

http://www.filemaker.com/help/Script-Steps62.html

--sd

[Adam M.]

Add the line

Commit Record/Requests[]

[Ben Ball]

Perfect, thankyou..