Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Jan 2004 @ 10:39:02 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Access and Decimal(15,5)
 
From:   Lerner, Dirk

Hi all,

for some tests we want to use Access as GUI for some tables. But we have problems with columns which are defined as decimal(15,5)

Table:

create table test
(x integer,
y decimal(15,5))


Scenario #1:
---------------------
Teradata V2R4
Access: MS Access 2000 SR3
ODBC: Teradata 3.00.01.03

I get from Access the error-msg: The field for decimal is too short and therefor no result.

Scenario #1:
---------------------
Teradata V2R5 Demo
Access: MS Access 2000 SR1
ODBC: Teradata 3.02.00.02

I receive the decimal values, but without any decimal point: 1234567 instead of 1234.567

So the data is useless...

Does anyone have a glue how to solve this problem?


Regards,

Dirk



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016