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

The coerce parameter qualifier, for UDF, tries to force the passed parameter to be the specified type. You did not specify any type with coerce which is not allowed.

Coerce supports the following converstions

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

Please go to the following link for more information on function parameter qualifiers.

Remedies

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

Sort by date Sort by score

Enable comment auto-refresher

You are not allowed to post comments.