Re: [firebird-support] How To Speed Up Update SQL

I've found that it often helps with an execute block when updates with complex join-like filter conditions apply. Something like this (untested): set term #; execute block as declare PK yourprimarykeycolumntype; begin for select MB.PRIMARYKEYCOLUMN from MY_BOOK MB inner join

[firebird-support] DUMP error on Firebird 2.5.4 on Debian Linux 8.2 Jessie 64 bits

This error happend during earling morning (04:40) where no one was using the Firebird database file. What is this problem and what may caused it? Motherboard: ASRock 990FX Extreme9 Processor: AMD FX(tm)-9590 Eight-Core Processor The server has 16gb of ram (DDR3 1600MHz). The Firebird database

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]

[firebird-support] Order by :variable in a Stored Procedure

Hi all, is it possible to pass a variable into a Order by ? I did it and the StoredProcedure was created without errors but the variable passed into an 'order by' was ignored and firebird assumed the primary key order instead any tip ? thanks

[firebird-support] FW: Scale-ability problems (PHP + firebird)

We host a php + firebird app for several years now, but as of late we are running into some scalability issues mainly with firebird. One of our new clients have about 120 users each which makes intensive use of the system and many requests to the database. The queries/indexes are all

Re: [firebird-support] Order by :variable in a Stored Procedure

If you pass a variable into an order by, it will sort on that *value*, and as that is the same for all rows, it is essentially a no-op. You can only do this by either sourcing the order by using a case to specify the column from a parameter, or by dynamically constructing the query, and

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