SQLDMO Field always returns 0 for NumericPrecision
-
SQLDMO ALWAYS returns 0 for Numeric Precision and Scale for a field. You can pull the actual values from system tables but with DMO - it seems to be a bug.
Has anybody else run into this issue?
Brian Lockwood
President
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials -
Just tested with a decimal column, returned fine. Get zeros for float, real, I suspect because they are preset.
Andy
-
quote:
Just tested with a decimal column, returned fine. Get zeros for float, real, I suspect because they are preset.Andy
http://www.sqlservercentral.com/columnists/awarren/
who are you going to believe me or SQLDMO?
Actually - I just retested this myself and I got a non 0 value for Decimal column ??? so you are right.
A user reported this issue and I thought I had confirmed it but ... it seems both of us were wrong.
thx Andy!!!!
Brian Lockwood
President
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply