Find problem on shared files.

February 14, 200322 yr

I have a find request that searches on a calculated field. Its basically, fieldX = 1. Everything is wonderful when running on the server. If I try to do the same find, fieldX = 1 from a client computer, I get invalid find request. I -think- I have all the nessisary related files open and being shared. "Looking closer now." But this has me totally stumped. Why would it disallow a find on a client computer?

Many thanks in advance.

-jim lee

February 15, 200322 yr

This is odd. Something is not right.

What version and *patch* level FMP are you using? It sould be 6.0v4 or 5.5v2 or 5.0v3 or something similar. Patch updates are free online from the FileMaker web site.

How is he file being shared? Is it on a network server where people open it by double-clicking on the icon?

February 15, 200322 yr

Sounds like a field type problem ...

Is it a scripted search or are you doing it by hand ?

What *exactly* are you entering in the field; what kind of field is it ?

February 15, 200322 yr

Author

I'm not at work rght now, so I'll have to "armwave" a little. When I get back in moday I'll be able to be more specific.

This database is being shared for the first time. I've been running and working on it for a year or two as a single user. Now its getting shared between 3 or 4 people and, of course, there are teething troubles.

All the filemaker s-ware is brand new out of the box. 6.x? I don't know what version. (Have to check monday)

This all started when a script failed. I tracked it down to this one field that won't allow searches on it from clients. Even by hand, it just won't work. Works fine when I'm on the server though.

The field is a calulation telling weather this certan part is somewhere in the assembly we are working with at the moment, -and- its parent assembly is in the acutal inventory that we are working with etc etc. Its in a recursive relational web of 4 database files.

Oh! I just remembered. I have the original version here at home. Let me dig up the paticulars..

The files:

parts - list of all possible parts (parts and assemblies, no difference)

assembly links - each record links one child part into its parent part assembly.

locations - list of all possible inventories.

part location links - each record links a part to a location.

This is the calculation that is giving me grief: "is in build" =

If(is top build assembly,1,If((location ID = current build location ID) and (Sum(master parts::is in build)>0),1,0))

I can't see anything special about the field format. I scratch my head wondering. Its a share problem, maybe something funky about globals?

like I said, flummoxed!

Thanks millions! For the help!

-jim lee

February 25, 200322 yr

Author

What? NO ideas at all? C'mon filemaker gurus, -someone- has to have run across something like this in the past. Or at least be able to shed some light on it.

I've certainly had no luck figuring it out.

-jim lee

February 25, 200322 yr

What do you mean by "it will not allow searches on it from a client"? What is actually happening?

Is the field stored or unstored? Unstored = unindexed and those can take a long time to complete, as Filemaker literally has to look at each and every record.

February 27, 200322 yr

Author

Exactly what happens..

Its a calculated field. It is either 0 or 1. Unsorted. When I'm sitting on the sever, I can go into find mode, put a "1" in the field and click "find" presto exactly the result I'm looking for.

If I do this on a client machine, I go to find mode, enter the "1" and click "Find". I get an immediate error dialog saying that there is no valid find criteria.

And, and.. and this is the coolest little spell checking thing I've ever seen on a www site. That's neat!

Anyway that's the problem. From a client machine I get an error message that there is no valid find criteria to do a search on. Running at the server, everything works as expected.

Any ideas?

-jim lee