Decimal/numeric fields - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Decimal/numeric fields

Author

Topic

issammansour
Yak Posting Veteran

51 Posts

Posted - 2007-09-19 : 10:40:55

Hi,

Database: MS SQL
Backend: Visual FoxPro ver 9

I have a table on SQL with numeric field (18,3), when create a cursoradaptor the become the a numeric field accept only int Value not allow to accept decimal. How to enable the field to accept decimal.

I am already:-
set fixed on
set decimal to 3

Best regards

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-19 : 10:50:39

Are you asking to change the datatype of the SQL column? If so:
ALTER TABLE YourTable ALTER COLUMN YourColumn DECIMAL

Future guru in the making.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-19 : 10:59:28

What is "cursoradaptor"?

E 12°55'05.25"
N 56°04'39.16"

issammansour
Yak Posting Veteran

51 Posts

Posted - 2007-09-19 : 11:18:52

Supports handling a wide range of data sources as native Visual FoxPro cursors. These data source types include the following:

Native

Open Database Connectivity (ODBC)

ActiveX Data Object (ADO)

Extensible Markup Language (XML)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources