expression size limitation

[David_Prince_(Guest)]

What is the size limitation for an expression?__I have a fairly lengthy expression i need to use, if there is a limitation, do you have any suggestions?____your help is very much appreciated.__thanks,

[kfleming]

There is both a character and a complexity limit.__What you can do is use more than one calculation and then have the first call the second rather than doing it all in a single calculation.__If you give me an example of what you need to do, I can give you a more concrete example.____Kathleen__R&R Support__

[David_Prince_(Guest)]

Kathleen,____Thanks for the reply, here is the case statement i would like to use:____CASE(CNG01_FLD, 102, "customer name", __103, "customer address 1", __104, "customer address 2", __105, "customer city", __106, "customer province",__107, "customer postal",__109, _customer phone",__110, "customer fax",__111, "customer contact",__112, "customer tax area",__113, customer purchase order",__114, "customer sales rep",__115, "customer start date",__116, "customer competitor from", __117, "customer end date",__118, "customer competitor to",__119, "customer end reason code",__120, "customer price code",__121, "customer email",__122, "customer cell phone",__123, "customer pager",__124, "customer custom 1",__125, "customer custom 2",__126, "customer custom 3",__133, "customer entity",__134, "customer credit limit",__135, "customer interest rate",__136, "customer charge interest",__137, "customer credit warning", __203, "location name",__204, "location address 1", __205, "location address 2",__206, "location city", __207, "location province", __208, "location postal", __210, "location phone", __211, "location fax", __212, "location contact", __213, "location tax area", __214, "location purchase order", __215, "location sales rep", __216, "location start date", __217, "location competitor from", __218, "location end date", __219, "location competitor to", __220, "location end reason code", __221, "location bill frequency code", __222, "location email",__223, "location cell phone", __224, "location pager",__225, "location invoice", __226, "location longitude", __227, "location lattitude",__228, "location estimated minutes",__229, "location business type", __230, "location custom 1",__231, "location custom 2",__239, "location document",__240, "location contract expiration date",__241, "location contact",__242, "location contract print date",__304, "service type", __305, "service quantity",__306, "service estimated minutes",__307, "service preferred arrival time",__308, "service start date",__309, "service end date",__310, "service end reason code",__400, "service charge changes",__401, "service charge changed",__500, "materials charge changes", __501, "material charge changed", __502, "parts charge changes", __503, "parts charge changed", __604, "schedule week code",__614, "schedule days", __615, "schedule last service date", _other_)______Your help is very much appreciated.__thanks,__David.__

[amy88]

I^ve used kathleen^s suggestion at least a few times before. You can cut up your expression into shorter expressions. For your example, you could break it into increments of 10 lines or so each with the last option (the "else" option) resulting in a blank or nothing.____You can then add a final expression, which is the sum of the sub expressions and trim off any leading or trailing blanks if necessary.____expresion1__CASE(CNG01_FLD, 102, "customer name", __103, "customer address 1", __104, "customer address 2", __105, "customer city", __106, "customer province",__107, "customer postal",__109, "customer phone",__110, "customer fax",__" ")____expression2__CASE(CNG01_FLD, 111, "customer contact",__112, "customer tax area",__113, "customer purchase order",__114, "customer sales rep",__115, "customer start date",__116, "customer competitor from", __117, "customer end date",__118, "customer competitor to",__119, "customer end reason code",__120, "customer price code",__" ")______expression3__iif(ltrim(expression1+expression2)>" ",__ltrim(expression1+expression2),"other")

[David_Prince_(Guest)]

Thank you very much. That helped and works perfectly.