Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Goto Next Record gives Error 101

Featured Replies

I only just noticed that the script step

Go to Record/Request?page [Next, Exit after last]

produces error 101 when it goes past the last record.

Error 101 is "Record is missing", which I can quite understand, however it seems odd to produce an error for a valid result as it should just 'Exit after last'

Yes it seems overkill, but why would it be a problem ... do you mean that it overwrites what earlier on is stored in Get(LastError) changing the logic, or is it stopping the execution of a IWP'ed script prematurely?

It seems just a loose end where internal and external messaging gets mixed up, not worth doing anything about?

--sd

This becomes annoying when you use the Debugger in the 'Pause on Error' mode or if the script is performed by server (the error is visible in the log)

Simply add Exit Loop If [ Get ( RecordNumber ) = Get ( FoundCount ) ] before the Go To Record [ Next ; Exit After Last ]

A pity nothing can be done with the find steps ( Perform Find, Constrain/Extend Foundset )

This becomes annoying when you use the Debugger in the 'Pause on Error' mode

The IWP argument I just mentioned, now you suggest a nice solution to the problem ... but another, could be to break the scripting needs up in digestible chunks of independent scripts.

--sd

  • 3 months later...

I'm running FileMaker Server 10 and I've noticed that I only get an error 101 for the Go to Record script step at the end of a loop if I have "Run with full access privileges" checked. Not sure why.

Warm regards,

Yaacov

Because it throws an error when there are no more records to go to "next"

In any case, I believe I am wrong about this.

My latest testing seems to show that the server log always records a 101 error, but I can avoid getting an error reported to me via e-mail if I have an additional step, such as a Go to Layout (original) at the end of the script.

I believe the access privileges thing was off-target.

Yes if there is an action that yields with no error AFTER the last go to record next of the loop, it seems to be fine.

I believe if you use Exit Script [1] it should work without errors as well.

Also take a look at this past thread where some of this was discussed.

http://fmforums.com/forum/showtopic.php?tid/197179/

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.