ActPresentation.com HOME FAQ FORUM info@ActPresentation.com
Phorum: speed & power.

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 ??

ACT! software CRM addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.