Jump to content

"Record is in use by 'Jane Doe'"


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

Recommended Posts

  • Newbies

My IWP clients get a blank screen if they try to commit a record which another user has open, or has inelegantly exited from. I'm trying (step 1) to provide a field that displays "Record is in use by 'Jane Doe'"

Get(RecordOpenState) is giving me no joy, either as a calculation in a field, or as a step in a script. Can someone point to a sample?

Maybe once my mental block clears, I can move on to step 2, which would be handling this error.

Many thanks in advance. . .

Link to comment
Share on other sites

Have you had a look at Get(LastError) ?

As this is a script driven event you will need to provide a button for the IWP user to "submit" the record (instead of using the Submit button in the status panel).

Roughly speaking your button should fire a script to:

Commit record

If Get (lastError) > 0 goto warning layout

Link to comment
Share on other sites

  • Newbies

Yes, I've tried that and found mixed results (thanks for the reply by the way). I think Get(LastError) worked in some cases, but not in others. I think I got a bit leary of that approach when I saw that Set Error Capture (which I percieved as necessary to reliably use Get(LastError)), was not web compatible. But I think I'll retry this approach without using Set Error Capture. It's just not clear to me (from the documentation) that "busy record" is one of the conditions that causes a >0 return from G(LE). Thanks for the tip - the next thing would be to capture who has the record, and to diplay that on the warning page.

Thanks!

Link to comment
Share on other sites

This topic is 6071 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.