Re: Problem creating a Trigger

2007-09-06 Thread Martijn Tonies
Hi, > However I have another problem which I need your ideas. It's better to create a new thread when you want to discuss a new problem. > I have a table where prices for a few stock tickers are inserted. I have > another temp table which holds the prices for the max trade date. I have a > trigg

Re: Problem creating a Trigger

2007-09-06 Thread anniyan
price difference. But I am unable to do it. DBD::mysql::st execute failed: Can't update table 'tbl_prices' in stored functio n/trigger because it is already used by statement which invoked this stored func pls advice -- View this message in context: http://www.nabble.com/Proble

Re: Problem creating a Trigger

2007-09-06 Thread Rolando Edwards \(DBA\)
ould 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: h

Problem creating a Trigger

2007-09-06 Thread anniyan
eclaration part. 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 arch