I think the problem is about decimal places, can I use this?

CREATE DOMAIN D_MOEDA AS
NUMERIC(16,5)
DEFAULT 0
CHECK (VALUE BETWEEN -99999999999999.99 AND +99999999999999.99)

I need to use at least 5 decimal places with DEFAUTL to 0.00, which is the
best type for that?

-----Mensagem original-----
De: Marco Parmeggiani [mailto:marcopar@...]
Enviada em: segunda-feira, 24 de maio de 2004 10:20
Para: Firebird-Java@yahoogroups.com
Assunto: Re: [despammed] [Firebird-Java] Absolutely boring...


In data Mon, 24 May 2004 08:29:03 -0300, hai scritto:

> Could anybody tell me why I have this boring error when trying to insert
> anything in my table, just 2 fields are NOT NULL, which I fill properly
> (considering the foreign key) BUT this error comes (the problem is that

can

> be one of three things wrong, but which one?):

some hints:
print out your insert statement and check every field...
then check if you're using characters from a charset not supported by
you're fields or conection...
do you use Preparedstatements? if not check the format of numbers, date and
time fields...

ciao

--
Seti@Home Java Applets
http://mrk.webhop.net/

Yahoo! Groups Sponsor
ADVERTISEMENT






Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004