ICONV crash (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== ICONV crash (OpenInsight Specific) ====
=== At 12 AUG 1999 05:51:34AM Colin Rule wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
A=ICONV(60200000,"MD9")



This line causes the system to debug with non-numeric.

Granted, this is not a good thing to do (I should have passed 6020.0000), but my program does some maths that needs large scaling.



We cannot guarantee what the user will enter, but you do not expect it to crash.

Please either return 0, exponential, or better still the correct result, rather than crash.

Hopefully a future release will resolve... 



TIA
</QUOTE>
----

=== At 12 AUG 1999 10:27AM Stephen Revelation wrote:  ===

<QUOTE>Colin,



This is a known limit of OI, being that the data is stored as 32-bit, which is the limitation on the datatype. 



If you haven't worked around the problem yet:



Since your users may exceed this number/limit in some cases, you would have to write a custom conversion on data that is need to be stored over this limit.  Data entered over a certain number, depending on your type of numbers and conversions, would have to be split over two fields. This is simply a limit to OI.  



To prevent breaking to debugger, which is a known problem, I could only suggest using a validation on the control to prevent the user from entering too large of data.



Regards,



-Stephen

</QUOTE>

----

=== At 12 AUG 1999 12:32PM dsig@teleport.com wrote:  ===

<QUOTE>Stephen,



Although it is true that OI can't do conversions on really large nbrs etc a better answer for OI would be return null just like an invalid conversion.  Going to the debugger seems a little harsh.



Is this in the problem files?



dsig@teleport.com onmouseover=window.status=imagine ... ;return(true)"

David Tod Sigafoos ~ SigSolutions

Cell: 503-341-2983

dsig@teleport.com

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0080F4850DB88579852567CB003628F5|View this thread on the  forum...]]