From: Martijn Tonies Date: December 6 2008 7:47pm Subject: Re: Trying to Create a Trigger List-Archive: http://lists.mysql.com/mysql/215513 Message-Id: <000801c957db$8b0c4020$9c02a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit > Going back to the OP's problem - the original issue I believe was he was > using "old" instead of "OLD" (case-sensitive) - now that's sorted, MySQL > is complaining about a syntax error toward the end of the function > declaration. I'm surprised by the case sensitivity of OLD though, it works fine on my Windows system. If this is really it... then ugh... Case sensitivity on object names has to be one of the most retarted things ever... With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com