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.

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?

Thanks in advance.