Difference between revisions of "Error Messages/40318"

Line 7: Line 7:
 
= Cause  =
 
= Cause  =
  
The '''coerce''' parameter qualifier, for [[User-Defined Functions|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''' <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
  
'''Coerce''' supports the following converstions
+
{| cellspacing="0" cellpadding="1" border="1" style="width: 781px; height: 190px;"
 
 
{| cellspacing="1" cellpadding="1" border="1" style="width: 781px; height: 190px;"
 
 
|-
 
|-
 
| '''From<br>'''  
 
| '''From<br>'''  
Line 44: Line 44:
 
<br>  
 
<br>  
  
Please go to the following link for more information on [[Function_Parameter_Qualifiers#Parameter_qualifiers|function parameter qualifiers.]]
+
More at[[Function_Parameter_Qualifiers#Parameter_qualifiers|function parameter qualifiers.]]
  
 
= Remedies  =
 
= Remedies  =

Revision as of 23:47, 26 October 2013

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


More atfunction parameter qualifiers.

Remedies

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



You are not allowed to post comments.

Comments
<comments />