post the script
smells like your invoiceTotal field not being unstored as it should be.
It's a very long script, but the portion that I'm having an issue with is:
Enter Find Mode [ ]
Set Field [ jobs::balance; ">0" ]
Constrain Found Set [ ]
But like I said, it's also happening if I manually enter find mode and type into the jobs::balance field.
siplus, do you mean that the balance field should be unstored? It is unstored already.
Also wanted to clarify that the script had been working fine, and then randomly started having this issue a few days ago.
Actually, I think I fixed it. I saved a compacted copy and the problem went away, so I guess it was just some file corruption. Thanks!!
What version of FileMaker are You running?
- if saving a compressed copy helped, could be an index-problem
- 'balance' is a calculated field?
We'va had this when running FileMaker Server, there are issue reports about this - but IMHO only when the file is hosted by FMS
I have had the same problem at a older database that was converted into .fmp12 format. I took the index out of the field, closed FMS and make sure that the database is closed properly. Then open up FMS again and put index on. Then it works again.