Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Finds in Scripts


This topic is 8230 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I want to embed a find into a script, but the find may not always return a result (I.E. No records found). In my previous attempts, when nothing is found, a message pops up, and it leaves you with that. Since this will be running within a script, is there a way to do a "if no records found, skip" etc.

Thanks

-j

Link to comment
Share on other sites

Set error capture to ON

after the perform find step

insert an if statement:

Status(CurrentFoundCount) =0

Show message: "Sorry no records were found."

show all records

enter browse mode

else

insert rest of your script here...

endif

Link to comment
Share on other sites

At the top of your script, include 'Set Error Capture(On)'. This allows the script to trap not finding any records (or any other error). Immediately after the Peform Find step, insert 'Status(CurrentFoundCount)'. Either save it in a Setfield, or use it in an If test (it only survives one script step).

Link to comment
Share on other sites

Set error capture to ON

after the perform find step

insert an if statement:

Status(CurrentFoundCount) =0

Show message: "Sorry no records were found."

show all records

enter browse mode

else

insert rest of your script here...

endif

Link to comment
Share on other sites

quote:

Originally posted by Ocean West:

Set error capture to ON

after the perform find step

insert an if statement:

Status(CurrentFoundCount) =0

Show message: "Sorry no records were found."

show all records

enter browse mode

else

insert rest of your script here...

endif

Just to make sure, in my case...

Set error capture to ON

Perform find

if Status(CurrentFoundCount) =0

exit script (in my case)

else

continue performing script.

I just ahve to make sure that nothing will popup and halt the script. It's going ot be running automatically w/out anyone attending it at certain intervals. I can't have anything stopping it.

Link to comment
Share on other sites

Looks fine from down here. Just to confuse you, I always use:

If Status(Current Error) = 401

to see if no records were found.

There has been some discussion in the forums on which one of:

Status(CurrentError) = 401 or

Status(CurrentFoundCount) = 0

is best but I can't remember what the outcome was.

Russ

Link to comment
Share on other sites

quote:

Originally posted by Russell Baker:

Looks fine from down here. Just to confuse you, I always use:

If Status(Current Error) = 401

to see if no records were found.

There has been some discussion in the forums on which one of:

Status(CurrentError) = 401 or

Status(CurrentFoundCount) = 0

is best but I can't remember what the outcome was.

Russ

If FMI will change the "Status(CurrentError) = 401" to something else it will stop functioning. The second will work always.

Link to comment
Share on other sites

I mad a global field called ErrorCode. This hold the code for the while script, so the code can be used well after other steps have run and even after other finds have occurred.

code:


Set Error Capture [on]

Peform Find []

Set Field [ErrorCapture, Status(CurrentErrorCode)]

Set Error Capture [off]

If [ErrorCode <> 0]

If [ErrorCode = 401]

Show Message [No records found.]

Find All records

Exit Script

Else

Show Message [An error occurred.]

End If

End If

[ April 21, 2002, 05:27 PM: Message edited by: Vaughan ]

Link to comment
Share on other sites

This topic is 8230 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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