How to retrieve large numbers
Posted: Tue 28 Jun 2005 05:57
Is it possible to retrieve the full value of a large number? E.g. I run the following on a backup file, RESTORE HEADERONLY ..., and some fields in the resultset is defined as NUMERIC(25, 0). Using SDAC or ADO, the value is returned as a float field with some loss of precision, but I need the entire number.
Is it possible to somehow detect if the precision is larger than 15, than the field is retrieved as a string value instead of as a float? Thanks.
Ray Mond
Is it possible to somehow detect if the precision is larger than 15, than the field is retrieved as a string value instead of as a float? Thanks.
Ray Mond