I haven't tested this, but here's a thought. If you do a
select std_prod_scrap, (CTXT(std_prod_scrap)) FROM <table>
does the text column show the scientific notation? If so, then you could say
"where slen(ctxt(std_prod_scrap)) > 6" or something like that
Karen
-----Original Message-----
From: mike.ramsour <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Fri, Oct 10, 2014 11:29 am
Subject: [RBASE-L] - Searching for invalid DOUBLE data types
Good afternoon:
Is there a way to search a DOUBLE datatype column to find entries that have
been stored in scientific notation?
I discovered this anomaly in one ofmy databases when I did a reload on it.
Here's an example:
UNIT_NO INWGT OUTWGT STD_PROD_SCRAP COQ_PROD_SCRAP
-------- --------------- ------------------------------ ---------------
4116 282,100 278,055 724.08 4425.75
4117 193,145 192,955 34. 162.5
7103 5,683 5,683 -2.220446E-16 0.
7106 5,617 5,644 -4.86 -31.86
7107 5,472 5,463 1.62 10.62
I can ferret these entries out in atedious manner by comparing the original
database to the rebuilt one butI was hoping for a more expedient method.
Thanks for any suggestions.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone: 740-829-4340
Cell: 740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it
is addressed and may contain privileged, proprietary, or otherwise private
information.
If you are not the named addressee, you are not authorized to read, print,
retain, copy or disseminate this message or any part of it. If you have
received this message in error, please notify the sender immediately by e-mail
and delete all copies of the message.
