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 MY
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
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
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] Why can't I have a SUSPEND or UPDAT
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 w
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
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
Hi,
since firebird don't support parameters in events (at least last time i
checked that)
the only solution i have found to get notification with the new inserted ID is
by creating a logs table :
CREATE TABLE NOTIFICATIONS
(
ID_NOTIFICATION integer NOT NULL primary key,
NTF_ID i
I meant “However, If I comment out the first portion (as shone below) leaving
just the UPDATE clause it works fine and the “Commit” and “Rollback” buttons
ARE enabled”
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, November 03, 2015 10:10 AM
Walter,
While that answer is correct, the better answer would be for the Project to
modify engine and installer to be Windows Vista+ compliant and have all
configuration files stored in All Users\Application Data\Firebird and not in
Programs Files\Firebird
Sean
From: firebird-support@yahoogr
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 perform
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
--
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 executin
13 matches
Mail list logo