I'm using a Domain to define money fields in tables as follows:
CREATE DOMAIN "MONEY" AS NUMERIC(15, 2);
The large number of digits are needed to track corporate total yearly sales, etc. When I use IB 6 with SQL Dialect 3 using ZEOS controls (also set to SQL Dialect 3), I get (Overflow) displayed in these fields in either DBEdit or DBGrid controls.
What is my best alternative? I'm doing this project on literally no budget until a company buys it, so I prefer not to use purchased drivers or upgrade from Delphi 4 Professional right now. Are NUMERIC fields what you use for currency?
Thanks in advance.