|
ActPresentation.com
Add-ons for Sage ACT! CRM
|
ACT! addons by ActPresentation.com : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!
Incorrect syntax near word CASE...
Posted by: William Rips
Date: January 10, 2010 02:58AM
In the screen "Assign Formula"I have a calculation like e.g.:
CASE ([ShippingPort])
WHEN "New York" THEN "1000"
etc
etc
END
The "auto calculated formula" is always checked,cannot switch it off.Why?
others like "update all cont/clear target/protect" all UNchecked.
I get error:
INCORRECT SYNTAX NEAR THE WORD CASE.
This only when filling in the field "Shipping Port"
If I do a fresh cut and paste of the assign formula then NO ERROR.
I seems that during working, the formula is piling up with concanating the same formula
twice,so after "END", I see the same formula again,each time i fill in a Shipping Port.
Anybody helping me ??
|