How to retrieve large numbers

Ray Mond · Post by **Ray Mond** » 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

Ikar · Post by **Ikar** » Wed 29 Jun 2005 06:36

Please see TMSConnection.Options.NumericType description in SDAC help

Ray Mond · Post by **Ray Mond** » Wed 29 Jun 2005 08:32

Thanks for your help.

Ray Mond