- Thu Jul 05, 2018 4:59 am
#815031
Firstly I appreciate the support I found in this Fourm thank you to all who help and support me.
I followed the post here viewtopic.php?t=709602
viewtopic.php?t=709602
Not solved my problem
1- I have external database and connected to my process in dynaform I have id and name I just want when type the ID the name automatically fill .
2- I create the trigger bellow
$db='5095676575b30905c0bec46079475259';
$id=@@id;
$name=@@name;
$sql="SELECT BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = @@id";
@@name = executeQuery($sql, $db);
put the trigger after Dynafourm
3- I test out the forum nothing happened
4- I repeated the same scenario but using PM database locally its working
What my mistake?
I followed the post here viewtopic.php?t=709602
viewtopic.php?t=709602
Not solved my problem
1- I have external database and connected to my process in dynaform I have id and name I just want when type the ID the name automatically fill .
2- I create the trigger bellow
$db='5095676575b30905c0bec46079475259';
$id=@@id;
$name=@@name;
$sql="SELECT BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = @@id";
@@name = executeQuery($sql, $db);
put the trigger after Dynafourm
3- I test out the forum nothing happened
4- I repeated the same scenario but using PM database locally its working
What my mistake?