If the Custom Function is calculating in the Data Viewer, force quitting it will forget that. But if you put it in a field, it is not going to forget it. The best you can do is try to change layouts to one not based on the troubled table or go to layout mode. Once in another layout or layout mode, then manage database and delete the field. If you have a script that runs and does something in another table, you could open the file with the FMP URL and run that script to change layouts runs and FM doesn't think about all fields in a layout when running a script. So something like FMP://someURL.com/file.fmp12?script=somescript It means you have to know the exact name of the script though.
Personally I would open it and hit command/control - L to go to layout mode and just wait for FM to quit thinking.
Maybe someone will have a better idea.
1 of 1 people found this helpful
I tested similar idea, using .fmpsl (snapshot link)
Opening .fmpsl, layout went directly specified in it, at least onLayoutEnter trigger for the layout set in File option didn't fire.
.fmpsl is text (XML) file, so you can make it from any file, then edit it for target file.
Hi Taylor and user19752,
I will stop working with that file and work with a previous version, it's only a database to explore things, no real data.
Back to my broken database, when the database open, there is no Layout displayed. The only windows displayed are the Launch Center and a dialog called Database Update telling Records remaining to process. FMPA does not accept keyboard our mouse entries.
That's Ok, I learned two things: I am not that good at writing Custom Functions and I should test them properly !
Custom functions can be powerful and problematic. I personally avoid them because I prefer to do most such things in scripts. But there are times like in field calcs that a custom function will work and a script will not. So they have their place. But it is good to get a feel of how they work as well as what can break. Just mark that up to another degree at the University of Hard Knocks!
So they have their place. But it is good to get a feel of how they work as well as what can break. Just mark that up to another degree at the University of Hard Knocks!
Yes, my head is aching a lot ! I went back to the Training Series Advanced, and there is not a lot in there, unfortunately. Do you know where I could learn more about Custom Functions ? I feel that by trial, that may be a loooooooooooon way to learn.
I found out CFExplorer, a bit old but still works, but that does not help me a lot.
You should not have much trouble with CF's so long as they are not recursive.
Testing all complex calculations, whether SQL queries, custom functions or other expressions in the Data Viewer is a good idea.