Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 .bas Property doubt..............

Author  Topic 

Lathu
Starting Member

10 Posts

Posted - 2011-08-02 : 08:04:23
In the database--table--column(field) point of view what is the "NumericScale" and "Flags" properties ???

I created one DTS Package with .bas extension for transferring the data from Oracle to SqlServer Tables.

In the Bas file i saw some of the lines like.....

oColumn.Name = "Emp_Remarks"
oColumn.Ordinal = 2
oColumn.Flags = 8
oColumn.Size = 240
oColumn.dataType = 129
oColumn.Precision = 0
oColumn.NumericScale = 0
oColumn.Nullable = False

In the above what is that Flags and Numeric Scale properties.

Pls Tell me anyone........
   

- Advertisement -