[FX.php List] Update a field in all related records.

[Joel Shapiro]

Hi Greg

I'm surprised (pleasantly!) to hear that calling an FM script could  
have better performance than having PHP do all the processing.  I've  
got a project doing something similar to Joe's task, and I use an FM  
script, but I'd thought I was just being lazy and that an "all PHP"  
solution would be faster/stronger/more reliable... (and that maybe  
I'd get around to switching it someday ;)

Are there any guidelines or 'rules of thumb' about when using a  
FileMaker script is preferable to PHP scripting?

Best,
-Joel


On Mar 14, 2006, at 10:16 PM, Greg Lane wrote:

> Joe,
>
> You could do all of this through FX.php, but my recommendation  
> would be to write a FileMaker script to do the work and then simply  
> call that script from FX.php. It will be simpler to write and debug  
> and the performance will likely be better as well.
>
> Feel free to ask if you have questions about writing the FM script  
> or calling an FM script from PHP.
>
> Greg
>
>
> On Mar 14, 2006, at 7:48 AM, Scarpetta, Joe wrote:
>
>> I’m adding a button to a layout that needs to trigger the  
>> following action:
>>
>> I’m currently on the parent record.  So from here I need to:
>>
>> Update the field ‘vote to’ Affirmative on the parent
>> Set the field ‘submitted_date’ to Today.
>> Goto to the Related records based on the key that is stored as  
>> $recKey
>> Update the field  ‘vote to’ Affirmative on the child records
>> Goto to a new page showing the parent information as a confirmation.