Truncated zeros

[jtr...@qwest.net]

I am using an active server page to create an ADO record set to be used to
populate a Crystal Report or a delimited text file. The record set is
generated by a stored procedure. The issue is that trailing zeros in
numeric fields are being truncated. So 1000000.000 becomes 1 and 9500.000
becomes 95. This issue does not affect string or integer data. As a
workaround I can convert the data to a string data type in the stored
procedure and it will be correct. The problem is that this could require
modifying over a hundred stored procedures. I?d much rather resolve the
issue. Because the data is correct when the stored procedure is run I
thought it would be in the ODBC drives but updating to the latest drivers
available from Sybase did not resolve the issue.

Any ideas would be appreciated.

--jet

[George Saylor]

try setting in the advanced tab of DSN

SET ANSINULL OFF

This worked for us in a similar issue ( Crystal and truncated zeroes on
numeric fields ), solution was courtesy of Sybase tech support ( and we
can't thank them enough )

<jtr...@qwest.net> wrote in message
news:24F0144915050C47007123688525699E.007123788525699E@webforums...