ODP: [firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

hi, you got an error or what? regards,Karol Bieniaszewski Oryginalna wiadomość Od: "'stwizard' stwiz...@att.net [firebird-support]" Data: 03.11.2015 14:59 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-support]

Re: [firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

Hello Mike, Database Workbench won't enable the Commit/Rollback buttons on a plain SELECT, because this will require you to use them for every SELECT you perform. In the case of a SELECT-able Stored Procedure, this means it won't be able to detect your procedure is also modifying data. In the

RE: [firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

I’m sorry I should have been a little bit more concise on what I’m doing. I use Database Workbench v5 for all of my development needs. Running the stored procedure setting the V_REPORT = 1 in Database Workbench, I do get a results set. So far, so good. However, if I set V_REPORT = 0

Re: [firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

There are a number of areas where something slightly unusual works in Firebird but Database Workbench can't cope with it. Have you tried running it by typing EXECUTE PROCEDURE into isql? On 03/11/2015 16:09, 'stwizard' stwiz...@att.net [firebird-support] wrote: I’m sorry I should have been a

[firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

Greetings All, Firebird v 2.5.4 Many times I would like to run a report before I do an update. Why can’t I allow for both in one stored procedure? Look at the end of this stored procedure where I use V_REPORT. Thanks, Mike SET TERM ^^ ; CREATE PROCEDURE X_CHK_LEGAL_CASE_DATE