[FX.php List] Strange FX behavior

[David Ness]

Remember, to return a value that's derived from a relationship, the related file must be authorized for fx.php access, also.
 
--
David Ness,
Database Systems Programmer
 
Bonded Builders Warranty Group
1500 Kings Highway
Port Charlotte, FL 33980
800.749.0381 x3123 (National Toll Free)
941.255.3274 x3123 (Local)
 
 

________________________________

From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
Sent: Tuesday, May 01, 2007 11:30 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] Strange FX behavior


Here's something interesting. 

I can try everything with this database to return these problematic fields, but I think I know now why they won't return:

The client has <apparently> created some convoluted relationship to pull this name into this record; here's the message I see when I try to toggle indexing on this record:
 
<image removed>

I suspect this is why FX won't return it. The name it's trying to pull in is a calc field that concatenates first & last name, and was indexed; I tried toggling the indexing just to see if it would matter, which it didn't.

I've used related fields a million times in FX, so I know it's not just that... any thoughts? :)

Bob


On May 1, 2007, at 9:33 AM, Dale Bengston wrote:


	Erik tossed out a lot of good things to try. Another one is permissions. Does your web user in FMP have access to the new layout you created? 

	I have also had some success with selecting the fields on the layout that don't show up and choosing Bring to Front. Don't know if that's just crazy or what.

	Dale

	On May 1, 2007, at 9:09 AM, Bob Patin wrote:



		On May 1, 2007, at 12:46 AM, Erik Andreas Cayré wrote:


			There have been a few similar cases on the list, where the problem was a damaged layout...
			Have you tried creating a new layout?


		Tried it, didn't help.


			Are you searching on one layout and returning using another layout?


		Nope.


			Have you checked permissions aren't customised (limited acces to some fields)?


		I don't think that's the problem.


			Do you get an error from FX?


		Nope.


			How does the raw return data from FX look?
			Are you positve the Filemaker file in question has never crashed?


		Who knows... these files are such a mess. Today I'm going to try doing a query for that particular record, and just that one field, which I'm going to put on a test layout... very annoying.
		_______________________________________________
		FX.php_List mailing list
		FX.php_List at mail.iviking.org
		http://www.iviking.org/mailman/listinfo/fx.php_list


	_______________________________________________
	FX.php_List mailing list
	FX.php_List at mail.iviking.org
	http://www.iviking.org/mailman/listinfo/fx.php_list


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070501/05c4f86a/attachment-0001.html