Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By ludovicsantaroni
#828414
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!
By Ironguts25
#828416
Is your syntax correct? Shouldn't you be using single quotes around your variables, like so:

('$SocieteAttribution', '$Exercice', '$NumeroChrono', '$NumeroAttribution')
By JayaChetty
#828422
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/
User avatar
By mbadino
#828423
ludovicsantaroni wrote: Tue Sep 15, 2020 11:04 am 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 ...
By Ironguts25
#828425
Ironguts25 wrote: Tue Sep 15, 2020 6:14 pm 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
Unable to create workspace

I have the same issue. Any solution? Thanks alex[…]

Install in ubuntu

Dear All, In our dev environment we did an upgrad[…]

Get data from oracle database.

How to display all data in a table from oracle DB […]

Hello everyone, I have the same route case issue, […]