Solved

Scripting Error 101

Posted on 2010-09-17
9
1,183 Views
Last Modified: 2012-05-10
I have a simple script that returns an error message although it does work.  It is a loop that substitutes blanks for ( ) and - in phone numbers.  The step before the loop is Go to Record/Request/Page first, and then in the loop is the step Go to Record/Request/Page next exit after last.  The script compatibility is set to server, and it does not show any incompatibilty.  I run this same script in several files, and it happens with each one.

Thanks!
0
Comment
Question by:Hobbs123
  • 4
  • 4
9 Comments
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33701495
Hobbs123,

Error code 101 is 'record is missing"

Is it possible your script is trying to go to one more record than what you have?

Did you try to run it with Script debugger to see what is happening?

good luck

tom
0
 

Author Comment

by:Hobbs123
ID: 33701806
You're probably correct, but I would probably have to do end it by a calculation to get rid of the error.  The script is:
Go to Record/Request/Page [First]
Loop
Set field to my substitute calculation
Go to Record/Request/Page [Next; Exit after Last]
End Loop

I guess that FM could be looking for another record, which would me it doesn't seem to know that was the last record.  Seems like a glitch to me, but maybe I'm just not thinking like a computer!
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33702013
Hobbs
What happens if there is no 1st record?

How do you find the records?

0
 

Author Comment

by:Hobbs123
ID: 33702190
It's a Show All Records, and there are always records there.  I'm in a school district and this is a demographic file.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 6

Expert Comment

by:ThomDroz
ID: 33702924
Hobbs123

Are you useing Advanced so you can run the script debugger...
0
 

Author Comment

by:Hobbs123
ID: 33703103
Yes, and I have run the script debugger on it and get the same error message.
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33703395
Hobbs123

What I would be interested in knowing is when does the error happen in the debugger?

On which record?

If it is the last do you see it happen when it gets to the "on last record exit" command?


thanks!
0
 

Author Comment

by:Hobbs123
ID: 33703688
Just checked it and the error comes up on the last record on the "Go to Record/Request/Page [Next, Exit after Last]" step.  Which I assume it's looking for one more record and doesn't know that was the last.  do I have it in the wrong spot???

Thanks!
0
 
LVL 8

Accepted Solution

by:
Tocacar earned 500 total points
ID: 33707619
I have a server script that loops through records and does exactly the same thing (leaves a 101 error after the last record).  I think there is another recent question on here with the same query.  You can simply ignore the error by putting script step 'Set Error Capture' (set to 'on') at the top of the script, or just at the top of the loop.  This will suppress the error and you can forget about it.  It just means that when the loop gets to the end of the found set, it doesn't find a record (101 - record missing) and so knows to exit the loop.  Nothing to worry about.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now