calling Database stored procedures from Phreeze

[Denace]

Hi Jason, Hope you are well. I've continued tinkering with my Phreeze app, setup all my DB back-end with stored procedures to dynamically calculate and update values based on user input. My question is how and where best to call my stored procedure from. Additionally the procedure should be invoked after a data update. I tried triggers but they keep getting locked because of write locks on the DB while my procedure runs.

[jasonhinkle]

Hmm I would think the triggers would work. If not, you can edit your controller and in the update/insert method just run your stored procedure manually using $this->Phreezer->DataAdapter->Execute("sql code here...");

[jailton2018]

Hi Denace you would have some example of how to call some procedure or triggers for me to draw as base. Thank you very much in advance.

[Denace]

jailton2018 I'll check. I haven't been developing on phreeze for a few months. Get back to you soon

On Mon, Jan 16, 2017 at 4:04 PM, jailton2018 [email protected] wrote:

Hi Denace you would have some example of how to call some procedure or triggers for me to draw as base. Thank you very much in advance.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/jasonhinkle/phreeze/issues/229#issuecomment-272857111, or mute the thread https://github.com/notifications/unsubscribe-auth/AKbx4gqXRANWc2pQJBJOdEasgERI1OcFks5rS2rRgaJpZM4GnETN .

-- Dennis Kieme