Recordset is removing zeroes

From: Ross (anonymous_at_discussions.microsoft.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 14:41:04 -0700

I have some VB 6 code that has been working for the couple of years, and 2 months ago I loaded the following patches on my machine:
mdac 2.7 setup
mdac 2.7
mdac_type 2.5_sp3
mdac_typ 2.50
mdac_typ 2.6.0.6526.3
mdac_typ 2.61
Q329414
VS 6sp5vb
VS6sp5
VS6sp6 - just loaded today on 5/21/04 and it did resolve problem.

I tried running a routine that has worked with no problem. Below is a test case that demonstrates what is happening to me.
  sSql = "select * from tableA where file_name = 'somefile.txt' order by file_name"
  rsDisplay.Open sSql, sConnSybase, adOpenDynamic
   
  sSql = "select int_value from tableB where int_value = 20"
  rsAdo.Open sSql, sConnSybase, adOpenDynamic

*** I get many records returned from the rsDisplay recordset, and I get one record returned from the rsAdo recordset.
rsAdo("int_value") should be 20, but it is 2. This happens for all numeric fields with a zero at the end (770=>77, 10=>1,20=>2, 30=>3, etc....).
When I close out rsDisplay and set it to nothing, then call rsAdo - 20 is returned.
This worked fine before all the patches.

Do you have any ideas as to what patch might have caused this or what else this might be?

Thanks,
Ross

Relevant Pages

  • Recordset trims values
    ... rsDisplay.Open sSql, sConnSybase, adOpenDynamic ... *** I get many records returned from the rsDisplay recordset, and I get one record returned from the rsAdo recordset. ... This worked fine before all the patches. ...
    (microsoft.public.vb.database)
  • Re: Recordset trims values
    ... Hi Ross, do you had installed Jet Service Pack,.? ... > rsDisplay.Open sSql, sConnSybase, adOpenDynamic ... > *** I get many records returned from the rsDisplay recordset, ... one record returned from the rsAdo recordset. ...
    (microsoft.public.vb.database)