Field not populating--why?

[Christopher Feyrer]

Dealing with another's code, I am trying to do the following.

I am trying to perform a search on a newly defined text field using a pre-existing form. This form allows you to specify an account# and other information. Maintaining the orignal coders' convention -- criteria is plugged into it using Insert Calculation with the defined calcluation being a given field; simple enough. Next, the layout is changed to a layout which contains all fields in the database to finalize the search criteria. Finally, Perform Find is issued to execute the find.

However, when I add my own new field to the form, and then reference it using Insert Calculation to put the info into the field to be searched - and perform a find, it doesn't populate on the layout, and therefore the info is ignored on the find.

Any ideas on where to start troubleshooting this?

Can i have some recommendations on how to best troubleshoot the problem?

[-Queue-]

What type of information are you trying to Insert? Could you do it with a Set Field[]? Insert Calculation requires the referenced field to be present on the current layout. Have you added your new field to the 'all fields' layout?

[Christopher Feyrer]

The new field is on the all fields layout. I've tried also with set field -- it's a text based field.

[BobWeaver]

When using the "insert calculated result" script step you have to make sure that you have allowed entry into the field. Check your field format to make sure. That is the advantage to using the Set Field command. It works no matter what formatting you have and even if the field isn't on the current layout.

Even if the previous developer has a lot of Insert Calculated result steps, I recommend that you don't use them for any new work, regardless whether it makes things look inconsistent. They create a lot of problems.

Only exception is when you are entering a range in a time or date field. In that case a Set Field doesn't work.

Other things to check:

- Check the settings of the restore option in your Enter Find and Perform Find steps.

- Make sure you are in the correct mode when the data is inserted. If you enter it in browse mode for example, and then switch to find mode it will disappear.

- Check to see if the existing fields are globals rather than regular fields. Make sure the one you added is the same kind.