[ludovicsantaroni]

Hello,

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)";
executeQuery($queryINSERT);

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!

[Ironguts25]

Is your syntax correct? Shouldn't you be using single quotes around your variables, like so:

('$SocieteAttribution', '$Exercice', '$NumeroChrono', '$NumeroAttribution')

[ludovicsantaroni]

Yes, it works now. Thanks you for your response!

[JayaChetty]

Commonly, the two main platforms, iOS, and Android are holding the entire market portion. Though Android handles the broader domains than iOS, the growth rate is higher on the iOS application. FITA is the best IOS Training Institute in Chennai. The trainers from FITA are Well- Experienced in IOS Training in Chennai.
Web: https://www.fita.in/ios-developer-training-institutes-in-chennai/

[mbadino]

Hello,

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)";
executeQuery($queryINSERT);

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!

HI, I made severals dynaforms with grid variables and string variables, Do you know if it is posible to insert and how grid and global variables in a PM Table? With report table is not so easy ...

[Ironguts25]

Is your syntax correct? Shouldn't you be using single quotes around your variables, like so:

('$SocieteAttribution', '$Exercice', '$NumeroChrono', '$NumeroAttribution')

Please note, single quotes should not be used if the variable is a number.

https://wiki.processmaker.com/3.5/DynaForm_Control_Properties#Rules_to_Correctly_Create_a_SQL_Query