[FX.php List] fx_error Object

[Michael Layne]

one possibility (saw this problem here before) is that if you have a 
related field on a layout and it is  empty - the relationship hasn't 
yet been established on a particular record - you get the error.

The solution is to wrap that field in a portal of that 
relationship/stick it in the portal.  Even if the field on that record 
is blank, it somehow fixes it.

HTH,

Michael

On Jan 20, 2005, at 5:16 PM, Jordan Sandford wrote:

> Hello all,
>
> I have a FileMaker 7 database with 3 tables. They are: invoices, 
> snapshots1, clients. In my relationship graph, the invoices is related 
> to snapshots twice; so I have snapshots1 and snapshots2 in my 
> relationship graph. A layout, called L_invoices, has a field that 
> refers to the snapshots table. The problem is that whenever I try to 
> use FMFindAll or FMFind() using the L_invoices layout, I get an 
> fx_error Object with a code of 100 (File doesn't exist). If I delete 
> that field that refers to the snapshots1 table, and use FMFindAll(), 
> it works.
>
> Also, I use the define("DEBUG", true) statement and it outputs a link 
> I can click on. When I click on the link and then view the source 
> code, I see good data.
>
> In addition, with the related field in the layout, when I use FMView() 
> I get get good data back from FX.php.
>
> I don't know if this is a bug or what, but any help is appreciated.
>
>
> Sincerely,
> Jordan
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>

Michael Layne  :  9 degrees development  :  www.9degrees.com  :  
404.226.7835
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1696 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20050120/ac167908/attachment.bin