Next record calculation

[yaron]

Hi guys, and good morning.

I have a small question hopefully Ill get the answer.

Id like to create a button for "Next record"

but I want it to take me not to the exact next record but to a record a head where a certain field's value is > 0.

I tried several options and couldnt make it work .

thanks.

Yaron.

[John Mark Osborne]

You'll want to use a looping script something like this:

Loop

Go to Record/Request/Page [Next, exit after last]

Exit Loop If [MYTABLE::CertainField > 0]

End Loop

[yaron]

Thanks, I just figured now how to write this script.

How do I attach this script to a button,

meaning how do I add it to the list of scripts so I can choose it on "Button Setup" ?

[John Mark Osborne]

Create the script in ScriptMaker under the Scripts menu. Then, you will be able to choose this script when creating a button if you select the Perform Script step from the Button Definition dialog.