Precision's value must be between 0 and 8!

[David]

Hi,

I have successfully imported an Informix DB schema from ODBC. However I received the above message when I try to save text in the Notes area for a Column/Attribute with a datatype DECIMAL. The existing Precision = 12 and the Scale = 2, so why must this be altered

Is this a known issue, does anyone have a workaround

TIA

David

[David]

I received a fix via direct e-mail from SparxSupport (see below), works as expected now.  

Please collect the InformixDatatypes.zip from the attachment. Please open up EA and select the Tools | Import Reference Data menu option. The Import reference data dialog displays. Select the filename to import data from the attachment. After that try to save text in the Notes area for a Column/Attribute with a datatype DECIMAL.

Hope can help you!

Best Regards,
 
 Ning Li
 Sparx Systems Pty Ltd

HTH

David

[«Midnight»]

Hopefully Sparx will post that file so others can use it.

And hopefully the information therein will be included in the EA 7.1 production EABase project, so we'll all have it in future projects.

(yet another) David

[David]

Out of all the David's I'm the old quite one  

Date Registered: Nov 6th, 2002, 2:34pm
1940 Days since joining

[«Midnight»]

Yeah,

We're oldies, but goodies!

David (they'll never guess which one now)