AnsweredAssumed Answered

Scripting syntex inquiry for the "Specify Field Calculation" window.

Question asked by jenh on May 31, 2011
Latest reply on Jun 3, 2011 by aammondd

Title

Scripting syntex inquiry for the "Specify Field Calculation" window.

Post

In scripting.

At the “Specify field Calculation” window.  

I tried entering the following conditions ….

Table::_FIELD1_  < .095 and  > .105 or

Table::_FIELD2 _ < .095 and  > .105 or

Table::_FIELD3_ < .095 and  > .105 or

Table::_FIELD4_ < .095 and  > .105 and

Table::_FIELDA_ = "TEST FAILED" or

Table::_FIELDB_ = "TEST FAILED" and

Table::_FIELDC_ = " TEST FAILED"

 The message I get is “A number, text constant, field name, or “)” is expected here.”

The message points to the first “>” .

Thank you.   Any suggestion is appreciated.

I also tried to identify the conditions above for fields 1-4 in the layout mode.. condtional formatting and wanted the field to be highlighted if the range was field < 0.095 and > 0.105.  Conditional formatting just highlighted all fields.   Is the range in conditional formatting limited to whole numbers only?  

 

 

Outcomes