Hi,
Thank you so much for the prompt response. Those comments were good to be
kept in mind always.
I actually realised the mistake I was making as soon as I posted the problem
here. So I managed the solve the problem.
However I have another problem which I need your ideas.
I have a table where pri
Hi all,
When I am trying to create a trigger I get an error message which I am
unable to comprehend.
create trigger updatepricech
after insert on tbl_prices for each row
BEGIN
DECLARE closep INTEGER;
select close into closep from temptable where Ticker = new.Ticker;
update tbl_prices set Pr