October 25, 2002 at 10:41 pm
Hello All
I am trying to write some statistical functions that use big numbers, like Factorial and Fisher Exact Test, ... etc.
I keep getting an error from SQl server of numeric overflow for that data type Float, while I can run the same routine on VB6 using double data type.
1. Is Float the largest data type that can handle numbers?
2. Does it need to be declared with any arguments, e.g., Float(53) (did not work for me)
Thanks,
October 28, 2002 at 10:20 am
Not sure about the VB stuff, but I believe Decimal and numeric are the largest types. Go to 38 bytes. the float and real are 8 bytes using a matissa and value pair.
you might also take a page from LISP and perform the funciton in VB and store it as a char.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply