Re: Problem with trigger

2007-08-07 Thread Linos
I can not use foreign keys because i want to use this database in replication, thanks by the new idea for the trigger :). Zietlow, Elke escribió: > Hi, > > obviously you are not familiar with the feature of referential constraints, > which are very common and implemented in MaxDB, too. > These re

RE: Problem with trigger

2007-08-07 Thread Zietlow, Elke
Hi, obviously you are not familiar with the feature of referential constraints, which are very common and implemented in MaxDB, too. These referential constraints assure that only such values can be used for one column of table x which are stored in some other column in another table. This is exa

RE: Problem with trigger

2007-08-07 Thread Anhaus, Thomas
Linos wrote : > -Original Message- > From: Linos [mailto:[EMAIL PROTECTED] > Sent: Montag, 6. August 2007 22:20 > To: maxdb@lists.mysql.com > Subject: Problem with trigger > > Hello all, > i am trying to do a trigger that permits me be sure > that when the users > inserts a row us