Subject | Re: [IBO] Problem entering currency |
---|---|
Author | Helen Borrie |
Post date | 2001-12-02T23:13:55Z |
At 10:02 PM 02-12-01 +0000, you wrote:
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>Hello:Do you have the CURRENCY column attribute set for the columns, or, better, for the domain?
>
>I am having a strange problem. I have a query with 2 fields I want
>to treat as currency. I set up a domain as:
>
>DMCURRENCY AS NUMERIC(9,2) DEFAULT 0 NOT NULL;
>
>All seems to work fine except I can no longer enter a decimal point.
>
>Before adding the domain I could enter 12.34, now I can only enter
>whole numbers.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________