Jump to content

Replace Field Contents script step


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

Recommended Posts

  • Newbies

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

 

 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2857 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
 Share

×
×
  • Create New...

Important Information

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