Forum Discussion
FYI, one of the pros of script extensions is that ANYONE can edit a script extension, not just the developer. Change the extension from tcx to zip, open it in your favorite compression utility, find the code file, edit, update the zip, change the extension to tcx... and you're golden.
Hello
Appreciate your patience. Thanks for detailed extension.
I dont have any restrictions if it is VB or Java. I want to insert it as a Run Script and call it after every execution so that Withdrawn date is populated with some previous date so that product gets un-enrolled from user.
For the ease of connection string , I am able to connect to database to add a Db check point. Connection string is as given below
Provider=MSDASQL.1;Persist Security Info=False;User ID=enterprise_uat4;Data Source=UAT4.
Password you can keep it blank I will fill it out
I am also exploring it from db check point side where in I can write a custom Query in the last page of the wizard. However after writing it I am receiving the following error message
Database check point > Connection details > Custom Query > paste the following query
"Unable to execute SQL query
Command Text doesnt not return a result set "
SQL statement
Update student_course_enrolment
Set WITHDRAWN_DATE = '01-AUG-18'
Where STUDENT_COURSE_ENROLLEMNT_ID IN
(Select STUDENT_COURSE_ENROLLEMNT_ID from student_course_enrolment where student_id = XXXXXXX AND WITHDRAWN_DATE IS null );
My query doesn't return any value instead it will update Withdrawn date with some previous date so that product gets un-enrolled.
Thanks
Eswara V
Related Content
Recent Discussions
- 13 hours agoashly