Re: Designer 2000 won't let me create integer columns ! ? HELP!

From what I understand, Oracle Designer does this by design (pardon the phrase). It implements the "integer" datatype in the database as number(38), You should probably define the datatype as number with max.length but no decimal places, for example number(10).

Sameer

In article <7b3qj0$2jg$1_at_news.nist.gov>,   "Keith Kwiatek" <kkwiatek_at_nist.gov> wrote:
> Hello,
>
> I created a server model in designer 2000.
>
> After reviewing it, I noticed that it had changed all my integer types to
> number(38) !?
>
> I went back into the server model and sure enough the column type was
> number(38). So I changed the columns back to integer type... but when I
> generate the DDL, it still shows number(38) ! (although it does stay as
> integer in the server model)
>
> Oddly, I can change the column type to anything BUT integer.
>
> I have requeried the repository....
>
> I have tried deleting/adding the field....
>
> Any other Ideas?
>
> Keith
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 00:00:00 CET