FreeTDS Development Group

["Michael Suedkamp" <ms AT suedkm.franken.de>]

Brian,

I should have tested a little more before posting. I cannot obtain values 
like "1", "1.5", "2", "2.5". For some reason these kind of values I expect 
in our database.
However, I can obtain values like "1.4","1.6", "2.2" etc.    ???????

The field in MS SQL 7 is of the "real" type (4 byte).

I added this code to the value_as_string function in tdstest.c:

...
TDS_REAL theReal;
...
switch(type) {
  ...
  case 109:   // This value is reported for the column type 
              // for both real types.
              // I know I have to handle the 8 byte type differently ...
    memcpy(&theReal, value, 4);
    sprintf(result, "%.6f", theReal);
    break;
  ...
}

I fear I'm doing some very basic C programming error here (yes, I am C 
newbie).

Michael