How do the stored procedures?

Developers Programming
#1

First the problem:
I want to create in the database (MySQL) an event (Create EVENT …) so at defined intervals the user to draw attention to something.
These events should be managed by the system administrator.

My solution:

  1. View angelgt reads ais infomation_schema.events the Eventa.
  2. GRID / FORM Applocation created.
    3 All Forms of Field to ‘defined by Database’ set … since I can not save the view, but need the Insert button.

OK. That is not because an empty then ‘INSERT INTO’ statement is sent to the DB.

OK after I found out that the PREPARE statement xxxx FROM <Statements> no MySQL "CREATE EVENTS processed, I thought, I solve the problem as follows:

the stored procedure CREATE_EVENT (…) generates the SQL DDL statement and passes it back to the application and there it is simply in the after insert event with sc_exec_sq (running).
Unless the plan.

Now I ask myself, HOW DOES IT AGAIN DAMN WITH THE PROCEDURES AND OUT parameters?

I always get an error message that the x-th parameter is not a variable or NEW variable in a BEFORE TRIGGER would …

Has anyone any ideas??

#2

Re: How do the stored procedures?

Stored procedures are ideal if there is a circuitous section of business argumentation that needs to be performed involving a lot of database access. If this argumentation is appropriate in abounding altered places, again even better.This can abate arrangement traffic, because your applicant will forward to server alone stored action name instead of ample able queries text.

#3

Re: How do the stored procedures?

Hi! did you solve this problem?

I am running into the same problem and was wondering how to create recurring events…

any pointers??

Thanks!