Difference between revisions of "Error Messages/40318"

 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
= Error Message Examples  =
+
[[Category: Error messages]]
  
 +
== Error message examples  ==
 +
 +
<pre style="background:white; border:white; margin-left: 1em; font-style:italic">
 
  Error encountered in the parameter declaration for Function CovertToText while checking:
 
  Error encountered in the parameter declaration for Function CovertToText while checking:
 
  (X: coerce)
 
  (X: coerce)
 
  In the declaration for parameter X, you must specify a datatype when you use COERCE.
 
  In the declaration for parameter X, you must specify a datatype when you use COERCE.
 +
</pre>
  
= 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
+
{| class="wikitable"
 
 
{| cellspacing="1" cellpadding="1" border="1" style="width: 781px; height: 190px;"
 
 
|-
 
|-
 
| '''From<br>'''  
 
| '''From<br>'''  
Line 42: Line 46:
 
|}
 
|}
  
<br>
+
See more at [[Function_Parameter_Qualifiers#Parameter_qualifiers|function parameter qualifiers.]]
 
 
Please go to the following link for more information on [[Function_Parameter_Qualifiers#Parameter_qualifiers|function parameter qualifiers.]]
 
  
= Remedies  =
+
== Remedies  ==
  
 
Add the type you want the parameter to be coerced to.  
 
Add the type you want the parameter to be coerced to.  
  
<br><comments />
+
==See Also==
 +
* [[User-Defined Functions]]
 +
* [[Function calls and parameters]]
 +
* [[Function_parameter_qualifiers#Data_type_qualifiers|Data types of function parameters]]
 +
* [[Function Parameter Qualifiers]]
 +
* [[NumberToText]]
 +
* [[Datatype functions]]

Latest revision as of 23:03, 22 August 2016


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

Comments


You are not allowed to post comments.