Hi all

 

I'm having some trouble here. I'm trying to get Find and Replace to search for blank fields or positive values within an "order" field, within a found set, and replace those values with "0". Find and Replace is running within a script, and I keep getting the error: 

 

"The Find/Replace Option "Current Field" requires a selected field."

 

Before the Find/Replace is run, I have the script "GoTo Field" called "order". However it's not working.

 

How am I supposed to tell the script what field to Find/Replace in, and what is the calculation that would go in the "Find What" field to find blank or positive values?

 

Thank you!

The currently active field is lost after a Find.

 

Go To Layout

Enter Find Mode

Set Field [ TableOccurrence::Order; "="]

New Record/Request

Set Field [TableOcurrence::Order; ">0"]

Perform Find

Replace Field Contents [No dialog; TableOccurence::Order; "0"]

 

Be careful - Replace is awesome, but getting it wrong can be somewhat disastrous - there is no Undo from this. And this will replace every Order field that is blank or >0 with a 0