Replace Field Contents script step

[dariusb]

Hi

The final stage in a particular script is 'replace field contents' (it's 'replace with current contents' but I've also tried it with a calculated result just to see if the problem persists).  At this stage I don't have 'perform without dialog' checked, so the 'replace field contents dialog' comes up as usual. So I click replace, the dialog box disappears, but nothing else happens (the fields all remain empty).  But then, if I immediately select 'replace field contents' from the menu and click replace, everything happens as it should.  Is this a bug or am I missing something?

 

Many thanks for any help (first time post so apologies if it's in the wrong place)

Darius

 

 

[bcooney]

Is this a continuation of another thread? If not, you'll need to tell us much more. What field (w/type) and context and what is the calc you're using in Replace? Why aren't you using Set Field?

[dariusb]

Sorry - I suspected there wasn't enough information.  This script imports a set of records into the table, and this script step is to set a Number field (that hasn't been populated by the import)  to the same value for every record in the imported set.  The way I did it was to use Set Field for the first record and then Replace Field Contents with the checkbox Replace "Current Contents" checked in the dialog box.  Would it be better just to use a loop to set the field one record at a time?  (There'll generally be about 150-200 records in the imported set).

Many thanks for your time.

[bcooney]

You could use an auto-entered value for that field.

 

To use Replace Field Contents, you do not need to Set Field in the first record. Just use Replace Field Contents and define a calculation (the calculation can simply be the value that you wish to set). Remember, Replace Field Contents will skip any records that are locked. Looping thru the found set and using Set Field allows you to catch a record lock error. Even better, populate the records using a transactional setup.

[dariusb]

Thank you - works properly now without the initial Set Field.