Jump to content

updating existing records


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

Recommended Posts

I have done the update, thanks for that info.

However possibly I am not making my self clear. I have changed a layout, adding a calculated field. Bringing two text fields together. All new records, when placing text into the fields, yields the correct calculated field. However all the current existing records are not updated. How do I "push" FMP to look at all the existing records and cause the calculation to happen.

Thanks again

Link to comment
Share on other sites

But what is the field type? "Text"? "Number"? Or is it "Calculation"? Because if the field type listed in the Field Definitions dialog is not "Calculation", you're barking up the wrong tree as RalphL suggests. See attachment for clarification.

Jerry

FieldDef.jpg

Link to comment
Share on other sites

Ahhh, a Pittsburger-my original/and still is hometown. Sure do miss it.

Now to business. I understand the concept of what you are saying, but your "easily script it" comment is the problem. I have been looking for scripting books and such, and cannot find anything. I am not sure which way to go, to learn....I need a book or something.

Link to comment
Share on other sites

Well, if this is the only step you want to do, create a new script. Double-click "Replace Contents" on the left side, then set the options for the step below.

It sounds like you do not need to script it, though; i am guessing you created the auto-enter calc after entering many records and now want the previous ones to "catch up" with the others. If this is the case, forget the script. Click into your field, select "Replace Contents" from the Records menu, select "Replace with calculated result", then enter your desired calculation and execute the replace.

Hope dis helps yinz aht 'n'at. smile.gif

J

Link to comment
Share on other sites

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