Pause Resume Script Step and Getting Current ID on Resume

[GisMo]

Hey Everyone, I've been doing a lot of Pause/Resume script steps in a solution and I've got somewhat of a hack for the task I'm trying to accomplish, but I'm wondering/betting there is a simpler solution. 

 

For example, the work flow works something like this. There are Three tables Invoice, InvoiceItems, and Products.

 

The user is looking at the Invoice Layout and adds a InvoiceItem. Then, they need to pick a reference Product. From this point, I have a button on the InvoiceItem record that says "Add Product". I run a script that shows another "pop-up" window with a List View of Products with pictures. The Script is Paused. Each record has a button that says "Select". Once the user presses the button select, the window will close and the the Product ID is linked to the InvoiceItem.

 

The trick is to get the Product ID before the pop-up closes and save it to a variable. When I have the "Select" Button with script Step Resume Script it doesn't seem to enter/access the listed record I am selecting and therefore when I try to set variable ProductID = $ProductID...$ProductID is empty or the wrong one. I have a few hacks to work around this by splitting the script into two scripts, but I'm not totally happy with the solution and I'd prefer to keep it all in the same script.

 

Any ideas?

 

Thanks!

[comment]

Each record has a button that says "Select".

 

And what is the action assigned to that button? If it's Resume Script, and if your script does:

...
Pause Script
Set Variable [ $productID ; Products::ProductID ]
Close Window [ Current Window ]
...

then you should be fine.

[David Jondreau]

I've never liked Pause/Resume but used it because there was not better alternative...until Modal Windows! I suggest switching to making a New Window[] that can't be navigated away from and two scripts, one to start, one to end.

[GisMo]

I've never liked Pause/Resume but used it because there was not better alternative...until Modal Windows! I suggest switching to making a New Window[] that can't be navigated away from and two scripts, one to start, one to end.

 

That's exactly my current solution! A modal pop-up. I was trying to keep it all in once script for ease of management of local variables.

 

I main issue was when starting the routine, I press a button from the parent record, I need to capture the parent record ID. The script ends. So I need to store the ID in a global variable or global field somewhere. This way, when I "resume"  I can inject the parent record ID back into the new related records that the user is creating. I just need to be careful to clear out the global variable/field when I finish the script. There are some other issues, but I've got a nice working solution and the clients are happy.