Script

[jtringale]

Hi All,

I'm trying to write a script for a file that contains sum 100 records. I'd like the script to select all records, go to 5 different fields, and then clear the contents of the fields. I need the script to do this for all 100 records. I've written the script so that it performs a "Find ALl", then a "Go To Field" and then a "Clear Field". It does this for each of the 5 different fields. However, it is only performing this script on the 1st record and then stops.

Can anyone tell me how I can get this script to repeat the process on all 5 fields?

Thank you for your assistance and comments.

Joe T.

[dspires]

Loop

your stuff

goto record request page[Exit after last, Next]

end loop

[jtringale]

Thank you for your help with this. This works and does everything I want it to except that the routine is not hitting the first record of the database. Do you know why this may be happening?

Thanks again.

Joe

quote:

---

Originally posted by dspires:

Loop

your stuff

goto record request page[Exit after last, Next]

end loop

---

[yafreax]

add the line

Go to Record/Request First

immediatly before the loop.

Jeremy

------------------

Filemaker's kind of like a wife; easy to love, yet just so complicated.

[jtringale]

Thank you, Jeremy. I appreciate your help.

Joe

quote:

---

Originally posted by yafreax:

add the line

Go to Record/Request First

immediatly before the loop.

Jeremy

---

[jtringale]

Hi Jeremey,

I tried this and it still isn't hitting the first record. I must be doing something wrong. If you can help I'd appreciate it.

Joe

quote:

---

Originally posted by yafreax:

add the line

Go to Record/Request First

immediatly before the loop.

Jeremy

---

[yafreax]

write out the exact syntax of your script for us and let us take a look. . . ( even if it is real long it may lie somewhere at the top of the script )

Jeremy

[jtringale]

Will Do.

Thank you.

quote:

---

Originally posted by yafreax:

write out the exact syntax of your script for us and let us take a look. . . ( even if it is real long it may lie somewhere at the top of the script )

Jeremy

---

[jtringale]

Jeremy,

Here it is:

ENTER BROWSE MODE

GO TO LAYOUT

PRINT SETUP

FIND ALL

SORT (RESTORE)

LOOP

GO TO RECORD/REQUEST/PAGE (EXIT AFTER LAST/NEXT)

GO TO FIELD (

[yafreax]

well, on the above, you didn't insert the line

Goto record/request (first)

insert this line directly in front of the loop

If this was just a mistake in the posting, well there's only one more thing to do... put the

goto record ( next / exit after last )

as the very last step in the loop

This should fix it.

Jeremy

I keep typing the wrong thing, maybe i should profread!

[This message has been edited by yafreax (edited November 16, 2000).]

[This message has been edited by yafreax (edited November 16, 2000).]

[jtringale]

Thank you.

I'll try that.

Joe

quote:

---

Originally posted by yafreax:

well, on the above, you didn't insert the line

Goto record/request (first)

insert this line directly in front of the loop

If this was just a mistake in the posting, well there's only one more thing to do... put the

goto record ( next / exit after last )

as the very last step in the loop

This should fix it.

Jeremy

I keep typing the wrong thing, maybe i should profread!

[This message has been edited by yafreax (edited November 16, 2000).]

[This message has been edited by yafreax (edited November 16, 2000).]

---

[jtringale]

Hi Jeremy,

The latter solution fixed it. I placed it at the very end of the loop and before End Loop and Exit Loop. It then worked.

Thank you for your help!

Joe

quote:

---

Originally posted by jtringale:

Thank you.

I'll try that.

Joe

---