RE: [FSID] Delete-Trigger problem

2005-08-16 Thread Andreas Goldstein
OK, I got it! ;) As I searched in the deep of this mailinglist I found the solution to this issue: http://lists.mysql.com/maxdb/5178 (February 20 2002 12:54pm) What is stated there is, that only UPDATE-TRIGGER will have NEW and OLD, so for my purposes I have to modify my trigger as follows: CRE

[FSID] Delete-Trigger problem

2005-08-16 Thread Andreas Goldstein
Hi Listmembers! I am having problems to create a delete-trigger. Here is the example: CREATE TABLE address ( address_ID FIXED(10) DEFAULT SERIAL PRIMARY KEY, street VARCHAR(20), city VARCHAR(20), zipVARCHAR(5), region VARCHAR(2)) // CREATE TABLE customer ( customer_id FIXED(10) DEFAULT