[FX.php List] Strange FX behavior

[Erik Andreas Cayré]

Den 01/05/2007 kl. 23.29 skrev Bob Patin:

> 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:
> <Picture 1.png>

You said you are having problems with more than one field. Do these  
fields share the problem you described?
Could it be that the context needed for the field to evaluate simply  
isn't there (for whatever reason) when accessing it with CWP?

Could you replace the field wth one that has the same contents, but  
which is not evaluated in the same manner?
(eg. Use the field in the related table directly on the layout)

> 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
>
> <Picture 1.png>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



---
Erik Andreas Cayré
Spangsbjerg Møllevej 169
6705 Esbjerg Ø

Privat Tel: 75150512
Mobil: 40161183

---
»Interesse kan skabe læring på en skala sammenlignet med frygt, som  
en nuklear eksplosion i forhold til en kineser.«
--Stanley Kubrick

»Kun p....sure mennesker kan ændre verden. Innovation skabes ikke af  
'markedsanalyse', men af folk, der er afsindigt irriterede over  
tingenes tilstand «
--Tom Peters

»Hvis du ikke kan forklare det simpelt, forstår  du det ikke godt nok.«
-- Albert Einstein

»Hvis du ikke har tid til at gøre det rigtigt, hvornår vil du så have  
tid til at lave det om?«
-- John Wooden, basketball coach