[FX.php List] why doesn't a fields show? (Resolved)

[CSInfo]

I think I misspoke. FM Full access does not mean full access. You need to
check the XML box in the Edit Privilege set.
This fixed it.
Sorry about all the noise......

John 


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Chris Hansen
Sent: Wednesday, July 02, 2008 11:15 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] why doesn't a fields show? (Resolved)

John,

If I understand what you're saying correctly, I think this issue is actually
a password issue (as Alex suggested), and NOT related to separate files.  I
created two fresh FileMaker 9 files, related them, and then added fields
from the second file to the first one, here's the related metadata:

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="text1" TYPE="TEXT"/> <FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="text2" TYPE="TEXT"/> <FIELD EMPTYOK="YES"
MAXREPEAT="1" NAME="Rel_Test2::number1"  
TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Rel_Test2::number2"  
TYPE="NUMBER"/>

Note that it does seem to me that there may have been a version of FileMaker
server with a bug related to separate files, but at least in the latest
version of FMSA9 (9.0.3.326 on my Mac OS X machine) related fields in
separate files work fine, UNLESS the username and password used doesn't have
the necessary access to view those fields.  Note that insufficient
privileges to view a field will cause exactly what you're seeing.

HTH

--Chris Hansen
   FileMaker 7/8/9 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Jul 2, 2008, at 9:38 AM, CSInfo wrote:

> I resolved my own issue,
> The data DOES need to be in a local table. An example:
> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Invoices::Invoice Number"  
> TYPE="NUMBER"/>"
> Invoices is a local table in my .fp7 file.
> thanks for reading....
> John
>
> From: fx.php_list-bounces at mail.iviking.org 
> [mailto:fx.php_list-bounces at mail.iviking.org
> ] On Behalf Of CSInfo
> Sent: Wednesday, July 02, 2008 10:29 AM
> To: 'FX.php Discussion List'
> Subject: [FX.php List] why doesn't a fields show?
>
> I have a layout that has some local and related fields on it.  When I 
> look at the XML, the related fields to not show.
> In order to get the data do I have to query the second database (From 
> a second .fp7 file)? Or should the data be showing from the 
> relationship?
>
> Clip from XML result:
> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Phone3Number" TYPE="TEXT"/> 
> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="" TYPE=""/>
>
> the second fields should show DJ_Service::Profile where DJ_Service is 
> a table from the second .fp7 file.
>
> Thanks,
> John Funk
>
> _______________________________________________
> 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