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

[Bob Patin]

Make sure you're not storing the results...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060


On Oct 14, 2006, at 7: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20061014/63f13d93/attachment.html