Problem creating a Trigger

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 PriceCh = (Close - closep) where Ticker = new.Ticker and Trade_date = new.Trade_date;
end;

I get the error :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

Here line 4 is the declaration part.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Can you please let me know what could be wrong in this query?
--

View this message in context: http://www.nabble.com/Problem-creating-a-Trigger-tf4392021.html#a12522149 Sent from the MySQL - General mailing list archive at Nabble.com.

--

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@pantek.com Received on Thu Sep 6 09:04:39 2007