Hi Vishal, > I would also like to know that if I need to learn Triggers and Stored > Procedures then what document should I refer, I am am new for triggers > and SP. Googling is random way I see. Would you refer any good books > for this?
You'll find lots of free documentation under http://www.firebirdsql.org/en/documentation/ More specifically, here's the Language Reference: http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25.html with the chapter on triggers: http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-trgr.html and on Procedural SQL (the language you use inside triggers and Stored Procedures): http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-psql.html The Firebird FAQ is also very useful: http://www.firebirdfaq.org/ And Helen Borrie's Firebird Book is a great manual which also includes chapter(s) on SP's, triggers and PSQL. It's not free though! You'll find it here: https://www.ibphoenix.com/ (You may need to scroll down a bit.) Hope this helps! Cheers, Paul Vinkenoog