Hi Alan,
thanks for your reply.
i did a backup and restore with fb1.5.
but still i get "token unknown" when i do a "drop procedure month".
do i have to backup/restore with specail settings?
what do you mean with "SP's will be truncated"?

Falko

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > Hi,
> > I Have old databases with 3 procedures named day, month and year.
> > The DB's where created under IB5.6.
> > Now they run under FB1.5. with Dialect 1.
> > Because day,month, year are now keywords, i tried to drop the
procedures.
> > But dropping with "drop procedure month"
> > gets error "token unknown ... month".
> >
> > Is there another way to get rid of those procedures having keywords?
> > dropping the procedures under IB5.6. is not a solution.
> > Is it save to delete the procedures from the system tables like this
> >
> > delete from rdb$procedures where rdb$procedure_name="MONTH"
> > and
> > delete from rdb$procedure_paramters where rdb$procedure_name="MONTH"
> >
> > did i miss some other system tables?
> >
>
> if you backup and restore in 1.5 the SPs will be truncated, then you can
> drop them
> Alan
>
> >
> >
> > btw:
> > if i use old interbase gds32.dll "drop procedure month" works fine?!?!
> > With fbclient.dll not?!?!
> > So, what do the client-dlls have to do with SQL-Statements executed on
> > the server?
> > I thought they only pass the sql-statements as is?
> >
> > Thanks in advance
> >
> > Falko
>