[shereensoliman]

i have boolean variable that is can not be change it's value in trigger , i want to check for update row in database
like
$db = '3011588145f029b2e6c5b35006271957'; // UID for the database connection

if
(
executeQuery("UPDATE [dbo].[Roles] SET
[Name] = '".@@roleName."'
,[CountryID] = " .@@Country."
,[RoleDescription] = '".@@Description."'
,[IsActive] = ".@@Status[0] ."
,[LastUpdateDate] = '".date('Y-m-d H:i:s')."'
,[LastUpdatedby] = '".@@Updatedby."'

WHERE ID = " . @@ID ,$db) == 0)

{
@@databaseupdated = 0;}
else
{
@@databaseupdated = 1;}

@@databaseupdated value not updated to 0 or 1
Options5 posts
Return to “Using ProcessMaker 3”