At 11:11 AM 02-11-02 +0000, you wrote:

>I define a computed field as
>
>alter table ATable add AValue computed by (Qty*Price)
>
>(here both Qty and Price are of type Numeric(15,5) ).
>
>FB creates the new field of type Double Precision.
>
>This brings me a few problems.
>
>I would have preferred a field of type Numeric(15,5) , but I guess
>there is nothing to do...
>
>Or not ?

...
COMPUTED BY CAST(QTY * PRICE AS NUMERIC(15,5)),
....

heLen

>TIA
>
>Duilio Foschi
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/