Hi Rüdiger, Tthanks for your reply.
I changed the sequence like this: CREATE TABLE ArtTest( ArtNr VARCHAR(32), Bez1 VARCHAR(52), Preis FIXED(15,5), Bez2 LONG, CONSTRAINT ArtTest_PKey PRIMARY KEY (ArtNr) ) and now it works. Within my app it's not possible to split the SQL statements to long and not-long fields. But now I have a solution. We just have to change about 120 tables (not really - there are some tables without long fields) and then it works. I think SAP will work on it. Thanks. Yours Tilmann -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Rüdiger Mähl Gesendet: Mittwoch, 24. Oktober 2001 12:52 An: sapdb-general Cc: Tilmann Starke Betreff: Re: Again: VB6 ADO does not work with numeric data type "Tilmann Starke" <[EMAIL PROTECTED]> schrieb am 24.10.01: > CREATE TABLE ArtTest( > ArtNr VARCHAR(32), > Bez1 VARCHAR(52), > Bez2 LONG, > Preis FIXED(15,5), > CONSTRAINT ArtTest_PKey PRIMARY KEY (ArtNr) > ) > > and some data in it, we tried to read the data via ADO (2.6). > > Unfortunately all decimals of 'Preis' are dropped when 'Bez2' contains > nothing/is NULL. Looking into the database with SQL-Manager does give the > right result, but not with our app written in VB using ADO. I currently cannot reproduce your problem as I do not have VB up and running on my machine, but just a thought: Have you tried to change the sequence of the fields, so that Bez2 is the last column in your create table? Is the select working, if you specify all columns except Bez2? So you could perhaps use a second select just to get Bez2 as the only column? Obviously, it would only be a work-around. Rüdiger ________________________________________________________________ Lotto online tippen! Egal zu welcher Zeit, egal von welchem Ort. Mit dem WEB.DE Lottoservice. http://tippen2.web.de/?x=13
