[FX.php List] portal row ID

Vision Computer Consulting info at visioncomputerconsulting.com
Wed May 30 08:34:54 MDT 2007


I realized why I got the error. The data for flagging a phone number  
was of the wrong type. I converted the checkbox = on to a number and  
it works fine,

Thanks all.

On May 30, 2007, at 7:21 AM, Vision Computer Consulting wrote:

> 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
>>
>
> _______________________________________________
> 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