Archibald Strohalm

Anybody seen this before? We're running a fm server 8 v3 on win2000 server with about 100 clients (FM8 on WinXP Prof). Every now and then (say once every two weeks) every search from every client on every unindexable calculated field returns zero records while we know it should return something. When we restart de server, everything seems to work again. It's a mistery... Any help would be very much welcome.

Sorry, been gone for some time. Figured it out: Seems FM7/8 needs at least one relative file reference: "fmnet:/*/myfile". I removed all references but the absolute ones: "file:/*/myfile" just for the sake of being orderly. This is why filemaker DID show the data from the relationship but DID NOT allow find requests. Thanx anyhow...

Hi Guys & Girls, Is there a way to get the path of a file in a container field in FM6? I know the GetAsText in 7 does this, but this function is not yet available in 6 Thanx

I converted my .fp5 files to .fp7 and I am hosting these files on FM Server 7. Does anybody know why my find requests return zero results when i am trying to find data in a calculated field based on a relationship? When I move all dbs to my harddisc and open the files locally (FM pro 8) all is good... Any help very much appreciated!

Unfortunately i cannot use the Set Field command because i am trying to fill a temp database with specific fields of my portal. All this because i want to export a set of records instead of a single field of a single record to get rid of those annoying "char(11)" line breaks. So my script now does the following and it works: - loop through the portal with the "go to by value" command as suggested by RalphL. - fill a new record in a temp db with a specific field for each record in my portal. - export the temp db as a whole - delete all records in the temp db. thanks everyone for your thoughts on this

Thanx! Used the global field option, because it seems faster.

Anybody out there to help me with this? I'm trying to loop through a portal copying a field to a different database (not related). My problem is that Filemaker never makes it to the next row. It keeps copying and pasting the first row. This is the script: *********************************** Go to Portal Row[First] Loop Copy[select; pr::field] # paste contents via sub-script in external db: Perform Script[sub-Scripts;External: "db.fp5"] Go To Portal Row[Next; Exit After Last] End Loop *********************************** It seems the loop doesn't work because of the Copy command. Any thoughts on this anyone?