Hello Ricardo,
Thursday, October 2, 2003, 4:40:33 PM, you wrote:
RG> Hi all,
RG> I'm having a problem when trying to receive a result set from SQL Server 2000 via ADO.
RG> The table I want to read has some fields whose data type is numeric with precision : 14,6
RG> These fields shown in the grid or in the Rave Report, just appear with 4 decimals insted of 6.
RG> The data was wirtten correctly into SQL 2000. A Single select via Query Analizer, shows the result set as it is : 14,6 (precision).
RG> NOTE : If I use BDE rather than ADO, everything apprears OK in both dbgrid and Rave Report.
RG> Any Ideas with this ADO bug ?
If you are using parameters in query, you must set precision for each
floating point value.
--
Best regards,
Beret
Partager