Hi,

>
> Can any one tell me, how can I see if a view, trigger or stored
> procedure has become invalid, that is to say, when it must be recompiled
> o recreated.

Can't be. Firebird doesn't have the concept of "invalid objects".

> Is there any field in database catalog (RDB$ tables) which tells me
> this? Any script or tool which can help with this. Even more, how can I
> make this automatically after modifying database objects.
>
> We are working with Firebird 1.0.3 and Delphi 6 and sometimes our
> application doesn't work till we recompile a certain stored procedure.
>
> Any help about this?

Well, give us more info :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com