Field_Precision

Precision of the column.

Supported By

All Drivers

Value

1 .. Maximum precision for the type of the column

Associated Attribute

DF_FIELD_PRECISION (Integer)

Remarks

The driver will get the precision defined at the server. If you want to define a different precision in DataFlex from the precision at the server, you should use this setting. It defines the length of the column (together with Field_Length).

This keyword is normally used to make sure that two relating columns have the same length. This can be a problem when relating between tables of different back ends.

For example, DataFlex will report the length of a numeric field as a multiple of 2. SQL servers support lengths for numeric data that are not a multiple of 2. If you want to relate between an SQL numeric column of length 3 and a DataFlex field of length 4, you should set this property for that field to 4.

See Also

Column Keywords