Solved

unable to enter value in field on only some records

Posted on 2004-08-30
5
330 Views
Last Modified: 2010-04-27
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
Comment
Question by:kauakea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 250 total points
ID: 11945083
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
 
LVL 19

Assisted Solution

by:billmercer
billmercer earned 250 total points
ID: 11977524
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
 
LVL 28

Expert Comment

by:lesouef
ID: 12291419
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question