I'm trying to do this:
"CREATE UNIQUE DESCENDING INDEX IDX_ULTIMA_MISCARE ON
PREZENTARE(ID_ULTIMA_MISCARE)"
and I'm getting the following ISC Error Code: "335544351"
with the following ISC Error Message:
"Unsuccessful metadata update. Too many keys defined for index
IDX_ULTIMA_MISCARE".


--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u.
..> wrote:

>
> > There is only one column for the index and it's a number given by

a

> > generator (no duplicate values).
>
> What's the error number/code? Give as much codes as
> you can... GDS/ISC/whatever.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &

MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com
>
>
> > --- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.

tonies@u.

> > ..> wrote:
> > > Hi,
> > >
> > > > I encoutered this error while trying to create the index: "too
> > many
> > > > keys defined for index".
> > > > Can anyone help me understand why this happens and how to deal
> > with
> > > > this problem ?
> > >
> > > How many columns do you have in the index? Sounds like "too

much".

> > >
> > > With regards,
> > >
> > > Martijn Tonies
> > > Database Workbench - developer tool for InterBase, Firebird,

MySQL &

> > MS SQL
> > > Server.
> > > Upscene Productions
> > > http://www.upscene.com
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >