Difference between revisions of "Error Messages/40318"
AManandhar (talk | contribs) (Created page with '= Error Message Examples = Error encountered in the parameter declaration for Function CovertToText while checking: (X: coerce) In the declaration for parameter X, you must …') |
AManandhar (talk | contribs) |
||
| Line 7: | Line 7: | ||
= Cause = | = Cause = | ||
| − | The '''coerce''' parameter qualifier tries to force the passed parameter to be the specified type. You did not specify any type with '''coerce''' which is not allowed. | + | The '''coerce''' parameter qualifier, for [[user-defined_function|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 | '''Coerce''' supports the following converstions | ||
| − | {| cellspacing="1" cellpadding="1" border="1" style="width: | + | {| cellspacing="1" cellpadding="1" border="1" style="width: 781px; height: 190px;" |
|- | |- | ||
| − | | '''From<br>''' | + | | '''From<br>''' |
| − | | '''To'''<br> | + | | '''To'''<br> |
| '''Result'''<br> | | '''Result'''<br> | ||
|- | |- | ||
| − | | Null<br> | + | | Null<br> |
| − | | Text<br> | + | | Text<br> |
| "Null"<br> | | "Null"<br> | ||
|- | |- | ||
| − | | Number<br> | + | | Number<br> |
| − | | Text<br> | + | | Text<br> |
| Number as text, using the number format of the variable or function calling the function.<br> | | Number as text, using the number format of the variable or function calling the function.<br> | ||
|- | |- | ||
| − | | Text<br> | + | | Text<br> |
| − | | Number or Positive<br> | + | | Number or Positive<br> |
| If possible, interprets it as a date or number, using the number format.<br> | | If possible, interprets it as a date or number, using the number format.<br> | ||
|- | |- | ||
| − | | Null<br> | + | | Null<br> |
| − | | Reference<br> | + | | Reference<br> |
| \Null<br> | | \Null<br> | ||
|- | |- | ||
| − | | Number<br> | + | | Number<br> |
| − | | Reference<br> | + | | Reference<br> |
| \X<br> | | \X<br> | ||
|- | |- | ||
| − | | Text<br> | + | | Text<br> |
| − | | Reference<br> | + | | Reference<br> |
| \Text<br> | | \Text<br> | ||
|} | |} | ||
| − | <br> | + | <br> |
= Remedies = | = Remedies = | ||
| − | + | Add the type you want the parameter to be coerced to. | |
<br><comments /> | <br><comments /> | ||
Revision as of 19:38, 27 January 2010
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 |
Remedies
Add the type you want the parameter to be coerced to.
Comments
<comments />
Enable comment auto-refresher