How to get value 17.6358823529412 in variable

Old forum URL: forums.lhotka.net/forums/t/5862.aspx

vijay posted on Sunday, November 23, 2008

One record of cursor that i open has one column value as 17.6358823529412. I am not able to get this value with sdr.GetDecimal() or sdr.GetDouble(). How do i access this and assign to local variable?

Thanks

Cosmin replied on Monday, November 24, 2008

Are you sure is a numeric column?
Try sdr.GetValue() and cast it to a decimal after. If your column is varchar then you might have problems with the decimal point, dependeing on your regional settings.