[FX.php List] Updating Auto-Calc Text Fields!! GARR!!!

Dale Bengston dbengston at preservationstudio.com
Sun Oct 15 20:10:43 MDT 2006


Hi David,

Would it be useful to perform the same calculation in PHP and then  
feed that value to the Qty field?

Regards,
Dale


On Oct 15, 2006, at 12:12 AM, Chris Hansen wrote:

> Okay, I'm not sure if this would work, but it should be worth a  
> try...  Rather than setting the field directly, try setting a  
> global (use SetFMGlobal() if you're using FileMaker 7 or later),  
> and then call a FileMaker script to actually set the field...   
> Basically, I'm wondering if using a FileMaker script to do the work  
> would be more dependable.  Let me know if this works as advertised.
>
> Best,
>
> --Chris Hansen
>   FileMaker 7 Certified Developer
>   Creator of FX.php
>   "The best way from FileMaker to the Web."
>   www.iViking.org
>
>
> On Oct 14, 2006, at 6:58 AM, David Tinoco wrote:
>
>> Hi Guys,
>>
>> I am having a lot of trouble with the FMEdit function,  
>> specifically when trying to update an Auto-Calc Text Field.
>>
>> It edits the record and updates the field, but only sometimes  
>> performs the calculation.
>>
>> My code is pretty straightforward.
>>
>> $newitem=new FX($serverIP,$webCompanionPort);
>> $newitem->SetDBData('XXXXXXXXXX.fp7','XXXXXXX');
>> $newitem->SetDBPassword($webPW,$webUN);
>> $newitem->AddDBParam('OriginalQty',$qty);
>> $newitem->AddDBParam('Qty',$qty);
>> $newitem->AddDBParam('-recid',$checkitemData['Line_ID'][0]);
>> $newitemResult=$newitem->FMEdit();
>>
>> Qty is the auto-calc field. I have tried switching the order of  
>> originalqty and qty but it does the same. Is there some way to  
>> FORCE it to udpate the calculation?
>>
>> Thanks,
>> David
>>
>> Stay connected with the news, people, places and online services  
>> that matter to you on Live.com Try it!
>> _______________________________________________
>> 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