Subject | Problem with Numeric/Decimal fields |
---|---|
Author | Cédric Joubert |
Post date | 2005-01-16T07:33:23Z |
Hi,
I have some problem with numeric values. I'm using the last Firebird 1.5.2 version and IBOConsole 1.1.11.
I try to create a decimal field DECIMAL (9.2) or NUMERIC (9.2)
If I try to enter these value in IBOConsole :
Type = NUMERIC
Precision = 9
Scale = 2
or
Type = DECIMAL
Precision = 9
Scale = 2
And I have this error :
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -842
Precision must be from 1 to 18
May someone can tell me how I can do to create the field please ?
Cédric
[Non-text portions of this message have been removed]
I have some problem with numeric values. I'm using the last Firebird 1.5.2 version and IBOConsole 1.1.11.
I try to create a decimal field DECIMAL (9.2) or NUMERIC (9.2)
If I try to enter these value in IBOConsole :
Type = NUMERIC
Precision = 9
Scale = 2
or
Type = DECIMAL
Precision = 9
Scale = 2
And I have this error :
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -842
Precision must be from 1 to 18
May someone can tell me how I can do to create the field please ?
Cédric
[Non-text portions of this message have been removed]