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://ww
Hi Paul,
You Rocks !!!n Yes It is working as expected.
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?
Corrected Trigger
Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] schreef op
09-08-2017 11:58:
> I have put table name as Table_Name, which is actual table name.
>
> On Wednesday, 9 August 2017 3:27 PM, Vishal Tiwari
> wrote:
>
> Hi Paul,
>
> I am getting below error while executing the trigger you sh
I have put table name as Table_Name, which is actual table name.
On Wednesday, 9 August 2017 3:27 PM, Vishal Tiwari
wrote:
Hi Paul,
I am getting below error while executing the trigger you shared. May be because
of new FB version? I am executing using FlamRobin tool.
Please see error b
Hi Paul,
I am getting below error while executing the trigger you shared. May be because
of new FB version? I am executing using FlamRobin tool.
Please see error below:
*** IBPP::SQLException ***Context: Statement::Prepare( create trigger before
update on Table_Nameasbeginif (new.col3 is distinct
Hello Vishal,
> I have one table say "MyTable", which has five columns, say Col1,
> Col2,...,Col5 and it has 10 rows. Col5 is of Timestamp.
>
> My issue is, whenever I am updating Col3, that time, only for that row
> of Col5, Timestamp value should be updated to the current timestamp.
>
> What w