Error Messages/40318

Error message examples

 Error encountered in the parameter declaration for Function CovertToText while checking:
 (X: coerce)
 In the declaration for parameter X, you must specify a datatype when you use COERCE.

Cause

Coerce <t> is a parameter qualifier in the Parameters attribute of a Function. It specifies that the function, when called, should try to convert the actual parameter to the specified type <t>. You omitted any type <t>. The type may be Text, Number, or Reference

From	To	Result
Null	Text	"Null"
Number	Text	Number as text, using the number format of the variable or function calling the function.
Text	Number or Positive	If possible, interprets it as a date or number, using the number format.
Null	Reference	\Null
Number	Reference	\X
Text	Reference	\Text

See more at function parameter qualifiers.

Remedies

Add the type you want the parameter to be coerced to.

See Also

• User-Defined Functions
• Function calls and parameters
• Data types of function parameters
• Function Parameter Qualifiers
• NumberToText
• Datatype functions