Re: Problem with trigger

rm us immediately and destroy the > original transmittal. Thank you for your cooperation. > > > >> -Original Message- >> From: Linos [mailto:[EMAIL PROTECTED] >> Sent: Montag, 6. August 2007 22:20 >> To: maxdb@lists.mysql.com >> Subject: [LIKE

RE: Problem with trigger

t: Montag, 6. August 2007 22:20 > To: maxdb@lists.mysql.com > Subject: [LIKELY JUNK]Problem with trigger > > Hello all, > i am trying to do a trigger that permits me be sure > that when the users > inserts a row use a list of possible good values to any of the columns

RE: Problem with trigger

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 whe

Problem with trigger

Hello all, i am trying to do a trigger that permits me be sure that when the users inserts a row use a list of possible good values to any of the columns from other table where i maintain this list, i would like to have this list dynamic instead of a constraint because i dont want to touch

problem with trigger after update

Hello list, I'm trying to run a trigger on the following table T_PHARMACOECONOMICS id serial(10)... ... visit_date date oneyear_date date fiveyear_date date ... I need the values of oneyear_date and fiveyear_date be automatically generated from the visit_date column. I wrote a trigger for insert

...problem with trigger and variable

Hi @all, i need some advice with an trigger statement. When i execute this statement in the SQL Studio, i became this error. Error --- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-3005 POS(1) Invalid SQL statemen