Jump to content

Recommended Posts

Hi Olger,

No plug-ins, and as I mentioned, I could not reproduce it myself, so there is no way I can debug this. Just thought someone here would have a more intimate knowledge of Unknown Errors in FileMaker. Apparently and by definition, these things are just unknown errors, and should be accepted as one of the mysteries of life.

Link to post
Share on other sites

Good catch. Thanks. The error number in the linked article is completely different. But I suppose the cause of the error has been unknowingly taken away - I will follow FIleMaker's lead here and call this  "Unknown Solution: 1001" 🙂.

Probably a whole bunch of errors with QuickFind haven't been mapped to text strings yet. Looking at the linked article, it seems to me that the QuickFind engine is still going through a number of changes throughout the versions of server and client and have as different behaviour on both on them. Good to know, even though I do not expect to code QuickFinds in FMSE.

QuickFind is very useable and therefore a great feature, but it still has a number of unresolved problems, which lead to this kind of trouble.

In current (v18) behaviour it is not possible to disable QuickFind for all elements in your layout by "Select All -> Disable QuickFInd", if they are embedded within other objects, they are ignored. I know you can disable QuickFind in the layout properties, but my point here is that developers do not expect FileMaker to ignore those extra fields, and since they are buried into other objects, this is hard to debug, and causes all kinds of problems with QuickFind. Increasing the problem, QuickFind has no "default field properties" behaviour, which makes every newly added field to the layout enabled for QuickFind. Which makes way to many fields enabled for QuickFind, as most mortal developers forget to uncheck the box.

11 minutes ago, Peter Wagemans said:

Good to know, even though I do not expect to code QuickFinds in FMSE.

That was a stupid comment. The OP said the QuickFInd behaves differently when the file was hosted ( by an FMS16 ) and that is not the same as a server side script, of course. It does maybe point to improvements and might work correctly when the file would be hosted by an FMS18.

Link to post
Share on other sites
  • 3 weeks later...


I am getting this error as well, but from a GTRR script step. I turns out the relationship was invalid as the field on the right side of relationship ( child ) was using an unstored calculation.

Hopefully, this is useful to someone.

Kind regards,




Link to post
Share on other sites

Thanks for that Joost.

Now that we know these are QuickFind issues with improperly or unsearchable related fields, we can now help FileMaker turn there Unknown Error message into something like “QuickFind Error. Some related fields on this layout cannot be used with QuickFind.”.

They will be so happy when we bring them the news. Imagine making something, and having this weird error number from your search engine you just can’t get your finger on. I know I would be happy if someone told me.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Kitesurfer
      I am pretty sure I have done this correctly but the result is not there.
      I have attached a few screenshots that will explain everything I believe.
      Looking forward to some help.
      PS. I have also had some issues importing excel sheets meaning the source fields (Excel did not show, therefore I could not line them up with the relevant Filemaker fields)
      Maybe my Filemaker is corrupted, although I have never encountered Filemaker be corrupted.
      Anyway hope someone can shed some light on this
      Kind regards

    • By DataCruncher
      This is strange. 
      Two FMS18 servers on Mac. 
      Both run a similar database file I had synced with mirrorsync. One of the tables is not that important but slowed mirrorsync down, so I decided to not mirror that table between server 1 and server 2, but instead make server 2 an external data source to server 1. 
      I add server 2 as external data source to server 1. 
      Then, things start to get weird. The table I wanted from eh external source I deleted from server 1. Yet, when I add server 2 as external datasource, it defaults back to the local file? 
      I can tell that's what's happening according to two observations: server 2 has the table X; server 1 does not as I deleted it. 
      Also, the external data source management windows shows file:FILE.fmp12 instead of fmnet://server2.xyz.com/FILE.fmp12
      How on earth can that happen? Filemaker seems to connect to server 2 but then think it's the same as the local file and decide for me to take the file on server 1 instead of the file on server 2?
      Very strange!
      Thank you!
    • By Spidey
      I have two table: Invoice and Customer.  I like to have the total of all the invoice for a customer between certain date in the Customer portal that show all the customers, but I got a error when I try to debug..
      ExecuteSQL("SELECT SUM(I.TotalAmount) FROM Invoice I JOIN Customer C ON I._kf_CustomerID = C.__kp_CustomerID WHERE date(I.InvoiceDate) between date(C.SearchFromDate ) and   date(C.SearchToDate )" ; "" ; "" )
      I have an error and couldn't figure it out.  Thanks...

    • By Todd Dignan
      I have a client that has been using a send email script step  that brings up the outlook email client on the desktop.  This as worked for years no problem.  It has stopped work on 3 of 35 computers within the last two weeks.  I talked with there IT personal and they have assured me that no updates have happened.  The actual error is -
      Microsoft Office Outlook
      Either there is no default mail client or the current mail client cannot
      fulfill the messaging request.  Please run Microsoft Outlook and set it as
      the default mail client.
      I have double checked with system default  and Outlook's settings.  Both are set to default.
      The client is using the latest version of office 360's and the latest version of FileMaker 18 advance. Both 64bit.
      Any suggestions are welcome.

    • By tbcomputerguy
      I have an excel sheet that controls bills of ladings for a forestry company.  In the example you can see that there is lots going on with this Bill.  It has a payperiod, mill, truck that delivered it, etc.
      I would like setup a database to monitor this.  The fields CT1, CT2, Skid1, Skid2. PROC1, PROC2 are all contractor numbers.  There are 6 contactors.  The percentages in each line are the amount of the volume they performed  In the third line there is a value in CT1 only...they get 100% of the volume.  I can figure out most of this, but am stumped on how I can monitor when a contractor does multiple jobs..ie in line one, contractor 5, cuts and skids.  All 6 contractors could be involved in one BOL. Each one of these jobs, cutting, skidding and processing each has their own respective rate of pay as well.   I think i need a way to break down each line so that I can produce pay summaries for each of the contractors.  I had started this years ago, and thought I asked in a forum, but can't remember where.  Nonetheless, they stopped using multiple contractors per load...Now they have returned, so I am back at it.  So if this is a repost from years ago I apologize.  
      Thanks in Advance

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.