Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

unable to enter value in field on only some records

Posted on 2004-08-30
5
Medium Priority
?
342 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
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 750 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 750 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

927 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