AnsweredAssumed Answered

Fieldnames function problem

Question asked by kj121 on Sep 15, 2011
Latest reply on Sep 27, 2011 by kj121

Summary

Fieldnames function problem

Product

FileMaker Pro

Version

11

Operating system version

OS X.5.8

Description of the issue

We run filemaker server 11.3 on a Mac OS server 10.5.8. Filemaker server is up to date.

My personal computer is running X.6.8. I made a db solution using script triggers and functions. On my computer it all works just as we want. I uploaded this onto the server and it is not working. It seems that the function not working is

FieldNames ( Get (FileName); "SearchFields" )

Even if I hard code the Filename it does not work.

I spent some time on this because I thought it must have been something I did but have proved that this is so. The db not working on the server works when I copy it and put it on my desktop.

Steps to reproduce the problem

Downloaded searchfilter form here as the sample:

http://www.excelisys.com/demos-free-filemaker-pro-downloads.php

Works on my computer, works when uploaded onto server.

Yet mine behaves the same way. Works on my computer (Filemaker 11.4)
Does not work hosted by server 11.3.

I know this means I must be blind but I have looked and looked, saved a compacted copy and on and on.

Expected result

To see a list of field names

Actual result

an empty box

NoFields.png

Outcomes