Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

[firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

The timestamp should be updated in Col5 only when Col3 is updated and not for any other column update. On Wednesday, 9 August 2017 2:20 PM, Vishal Tiwari wrote: Hi All, I have one issue to share with you. I have one table say "MyTable", which has five columns,