I turned the field into a float and then tried to enter the number
2.63e11
This is the error that I got back.... Not sure what I am doing wrong...
Thanx in advance....
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error
converting float to data type numeric.
SQL = "UPDATE dbo.Mech SET IxxEPV = 2.63e11 Where MechID = 12
Cori
At 09:43 AM 5/15/2001 +0100, DeVoil, Nick wrote:
>Corina
>
>You want float.
>
> From the docs:
>
>float [ ( n ) ]
>
>Is a floating point number data from - 1.79E + 308 through 1.79E + 308. n is
>the number of bits used to store the mantissa of the float number in
>scientific notation and thus dictates the precision and storage size. n must
>be a value from 1 through 53.
>
>Nick
>
>-----Original Message-----
>From: Corina Moore [mailto:[EMAIL PROTECTED]]
>Sent: Monday, May 14, 2001 9:18 PM
>To: SQL
>Subject: Exponentials & Data Types
>
>
>Our users need to be able to enter exponential information.
>(ex: 2.63e11)
>After they enter the information we need to be able to do calculations on
>it (mostly subtracting one exponential from another exponential)
>Any have any thoughts on the best data type to handle this.
>Thanx...
>*********************************
>Corina S. Moore
>IMDC Software Developer
>301-286-6124
>http://imdc.nasa.gov
>**********************************
>
>
>**********************************************************************
>Information in this email is confidential and may be privileged.
>It is intended for the addressee only. If you have received it in error,
>please notify the sender immediately and delete it from your system.
>You should not otherwise copy it, retransmit it or use or disclose its
>contents to anyone.
>Thank you for your co-operation.
>**********************************************************************
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
