Re: FLOAT
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
On Wed, 2 Nov 2005 14:47:07 -0500, Rogers wrote:
>I only want to use float datatype because I have to frequenly convert the
>database into Access 97 and Access doesn't support decimal and numeric
>datatype.
Hi Rogers,
I just did a quick test - create a table with a decimal(9,2) column in
SQL Server, then create a linked table in Access 97. Access defines the
column as double. I could enter and retrieve data without any problems
(other than data with more than two decimals being rounded).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
Relevant Pages
- Re: FLOAT
... Rogers wrote: ... > I only want to use float datatype because I have to frequenly convert ... > the database into Access 97 and Access doesn't support decimal and ... years old) has a Number Data Type, which can then be qualified with the ...
(microsoft.public.sqlserver.clients) - Issue in using round in Vbscript
... I am using a Round to get the Value of a Float datatype column from a database ... It do returns a value as 0 but it stores it into a table it's -1 my column for Temp is of Float datatype ...
(microsoft.public.sqlserver.server) - Re: New Column to DataSet.DataTable
... > I was not clear in my query. ... > I need to retrieve data from a database. ... Prev by Date: ...
(microsoft.public.dotnet.languages.csharp) - RE: Issue in using Round
... I am using a Round to get the Value of a Float datatype column from a database ... It do returns a value as 0 but it stores it into a table it's -1 my column for Temp is of Float datatype ...
(microsoft.public.sqlserver.server) - Re: New Column to DataSet.DataTable
... I was not clear in my query. ... I need to retrieve data from a database. ... Prev by Date: ...
(microsoft.public.dotnet.languages.csharp) |
|
