I want to insert an entry in a local PM Table with a trigger.
Here is the code I use to do it :
$queryINSERT = "INSERT INTO PMT_RVD_NAT_DI_NUMEROATTRIBUTION (CODESOCIETE,EXERCICE,NUMERO_CHRONO,NUMERO_ATTRIBUTION) VALUES ($SocieteAttribution,$Exercice,$NumeroChrono,$NumeroAttribution)";
Variables $SocieteAttribution,$Exercice,$NumeroChrono,$NumeroAttribution are defined in the same trigger.
This part doesn't work. Could you explain me what it's wrong ?
Thanks in advance!