Whenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will
not be[b] retrieved[/b] properly as the [b]previous form[/b] will [b]not be updated[/b]. I hope ur understanding ...
I have written the query in the [b]form code[/b] itself.
I have used [b]trigger[/b] once but that was on the Database side itself.
so,this time I am not understanding what to do!!
So what is the solution to make the database execute automatically once the code is being executed i.e. the details are sent to database?
IAmateur
Member
96 Points
388 Posts
Trigger
Apr 26, 2012 10:14 AM|LINK
Whenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly as the [b]previous form[/b] will [b]not be updated[/b]. I hope ur understanding ...
I have written the query in the [b]form code[/b] itself.
I have used [b]trigger[/b] once but that was on the Database side itself.
so,this time I am not understanding what to do!!
So what is the solution to make the database execute automatically once the code is being executed i.e. the details are sent to database?
Time to go Long way...