[FX.php List] portal row ID

Vision Computer Consulting info at visioncomputerconsulting.com
Wed May 30 08:21:05 MDT 2007


I can only make this work if I include the parent recid.

code looks like:

$phoneData_array = array (
						'Phone_Primary_Flag' => $phone_info_array 
['phone_info_array_workprimary'],
       					'Phone_Type'=> 'work',
       					'Phone_Number'=> $phone_info_array 
['phone_info_array_worknum'],
       					'Phone_Extension'=> $phone_info_array 
['phone_info_array_workprimary']
       				);
					//echo $phone_info_array[phone_info_array_worknum];
					$my_fx->SetPortalRow 
($phoneData_array,'3','Account_Contact_Phone_fx');
					$my_fx->AddDBParam('-recid',$recid);
					$fx_Result = $my_fx->FMEdit();

This does edit the record, but I am getting a '10' error saying data  
is missing. Any ideas?

On May 30, 2007, at 7:08 AM, Steve Winter wrote:

> Only if you're also making changes to data in that record, and that  
> will
> require a different FX call, since it will be to a different  
> database....
>
> If your databases are called Parent and Child, then your 'find'  
> will be
> against Parent, but when you edit the related records your FX call  
> will be
> to the Child database, using the record ID that you've got through the
> suggested field...
>
> Hope that makes sense...??
>
> Cheers
> Steve
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Vision  
> Computer
> Consulting
> Sent: Wednesday, 30 May 2007 3:03 p.m.
> To: FX.php Discussion List
> Subject: Re: [FX.php List] portal row ID
>
> Thank you David and Gjermund.
>
> Do I need the parent recid too for FMEdit()?
>
>
> On May 30, 2007, at 5:32 AM, David Ness wrote:
>
>> I would add a calculated field to the child (portal) table to
>> obtain the
>> record id:
>> "recID = Get ( RecordID )". Then use that field for your record ID.
>> Won't that do it?
>>
>>
>>
>>
>> --
>> 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)
>>
>>
>> -----Original Message-----
>> From: fx.php_list-bounces at mail.iviking.org
>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Vision
>> Computer Consulting
>> Sent: Tuesday, May 29, 2007 10:35 PM
>> To: FX.php Discussion List
>> Subject: [FX.php List] portal row ID
>>
>> I did find this syntax on the web in a FX,php post
>>
>> $myQuery->AddDBParam('RelationshipName::FieldName.xxxx');
>>
>> Circling on it, but in Filemaker 7, how does one find the value of
>> .xxxx?
>> _______________________________________________
>> 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
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.3/824 - Release Date:  
> 29/05/2007
> 1:01 p.m.
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.3/824 - Release Date:  
> 29/05/2007
> 1:01 p.m.
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>



More information about the FX.php_List mailing list