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

[Chris Hansen]

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