[FX.php List] Strange FX behavior

[Bob Patin]

Checked it... it's got XML turned on, although I wonder why it would  
need to, since it's not actually being accessed directly.

Does XML *really* have to be turned on even though the related file  
isn't talking to FX.php?

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060


On May 1, 2007, at 10:49 AM, David Ness wrote:

> 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
>
> _______________________________________________
> 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/2d2d3ebc/attachment.html