FYI I apologize if Mozilla converts this note in a crappy way ;) Dieter Fischer wrote:
Hello
I've a simple "Z SQL Method":
select * from zahlen
"zahlen" is the table, I've ddescribed in my email before. I can see the wrong numbers when I select the Test tab of the method.
Below the script for the Ora-Table:
CREATE TABLE ZAHLEN ( INTEGER_ INTEGER, NUMBER_10_1 NUMBER (10,1), NUMBER_10_2 NUMBER (10,2), NUMBER_10_5 NUMBER (10,5), DECIMAL_10_0 NUMBER (10), DECIMAL_10_1 NUMBER (10,1), DECIMAL_10_2 NUMBER (10,2), DECIMAL_10_5 NUMBER (10,5), REAL_ FLOAT (63), SMALLINT_ INTEGER, FLOAT_ FLOAT (10) ) ;
Regards
Dieter
I ran this, and inserted 100.5 into each column. Under Zope, I created an identical SQL method and then tested it: I got the following results: ------------------------------------------------------------------------ INTEGER NUMBER 10 1 NUMBER 10 2 NUMBER 10 5 DECIMAL 10 0 DECIMAL 10 1 DECIMAL 10 2 DECIMAL 10 5 REAL SMALLINT FLOAT 101 100.5 100.5 100.5 101 100.5 100.5 100.5 100.5 101 100.5 ------------------------------------------------------------------------ SQL used: select * from zahlen ------------------------------------------------------------------------ That's why I'm not sure what it is that you're doing differently. Under the "Debug" tab of the Connection I created, I have the following: Oracle version strings: * DCOracle2: (cvs release) -- DCOracle2 1.95 (dco2: 1.120 -DORACLE8i -DORACLE9i -DUSEOBJECT -Dlinux -D_REENTRANT ) * TNS for Linux: : 9.0.1.0.0 (Production) * Oracle9i Enterprise Edition : 9.0.1.0.0 (Production) * PL/SQL : 9.0.1.0.0 (Production) * NLSRTL : 9.0.1.0.0 (Production)