Precision of fields in a view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allen_N - 23 Jan 2007 03:02 GMT

is there any way to control the precision of a field in an ADP view? My
SELECT statement is multiplying 2 fields to create a 3rd, and the number of
decimal places in the output field seems to be the maximum of the precisions
of the input fields.

Reply to this Message

Baz - 23 Jan 2007 06:33 GMT

Use the SQL Server CAST or CONVERT function to ensure that the output column
is of the appropriate data type.

> is there any way to control the precision of a field in an ADP view? My
> SELECT statement is multiplying 2 fields to create a 3rd, and the number of
> decimal places in the output field seems to be the maximum of the precisions
> of the input fields.

Reply to this Message