• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

unable to enter value in field on only some records

i have a database that has 16 fields in it. i have one field defined as "marked selection" that i put a value of 1 in when i run a global find on the records from a script. my problem is that on some records i am unable to enter a value into this field. example: i run a search and 11 records are displayed. only 5 records have the marked selection field with a value of 1. while in the browse mode i am unable to manually put a value in this field for the records that do not have a value of 1 inserted by my script. i get a message
"before typing, press tab or click in a field, or choose new record menu command"
what could be causing this problem.
0
kauakea
Asked:
kauakea
  • 2
2 Solutions
 
lesouefCommented:
weird...
after the search, how do you enter 1s ? replace in the found set? loop and define field? loop and insert value?
the msg indicate something like trying to paste a value while no field is active...
if you have the dev version, step by step the script and you'll see what happens, otherwise, pause the script after search and after each entry to see what happens.
0
 
billmercerCommented:
Depending on how your database works, this could be normal behavior. As I understand, you're trying to enter the number 1 in a record where that field is currently blank, but it won't let you.

First, in layout mode, right-click on the field you're having trouble changing, choose Field Format (or Field Behavior if you are using FM7) and make sure the "allow entry into field" box is checked. Filemaker allows the value of a field to be modified by a script even if the field cannot be modified by you in browse mode. So if your field format doesn't have the "allow entry into field" box checked, you would get this error message when you try to edit the contents manually, even though your script can change the value successfully.

In fact, a script can even change a value for a field if you have set the field definition set to prohibit modification!

If on the other hand you mean that you CAN enter the field and make changes when the value is one, but not when the value is blank, then the only explanation I can think of is that the field is based on some sort of relationship. In that case, if there is no valid related record to display, then you would see a blank value for the field, and get the same error message you describe when trying to edit it.
Those records that do have related values will allow you to enter and edit them.



0
 
lesouefCommented:
this guy "kauakea" is familiar, and normally closes all his queries, but he does not come on a regular basis, he must be travelling or something, so maybe you can leave him a bit more time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now