Inside some of my triggers, I'm trying to detect if I'm at a top-level user-
requested operation, or nested inside other triggers. (I've done this for some
REDO triggers before, here I'm doing it for validation reasons -- there are
things
I don't want a user doing directly, but don't mind
-- Original Message ---
From: Leyne, Sean s...@broadviewsoftware.com
It is as expected, data type constraints are enforced before all other
operations.
What would be the purpose of firing a trigger if the data is not valid?
Sean
--- End of Original Message ---
Because
-- Original Message ---
From: Wewe sullen...@yahoo.com
select * from y
select value1+value2 as total from y
Which is better performance and speed? table x or table y ?
--- End of Original Message ---
I've never noticed a difference in performance at select time. I
-- Original Message ---
From: Dmitry Yemanov dim...@users.sourceforge.net
Out of curiosity, did you try playing with -D ON/OFF modes for
nbackup? If so, does it make any difference?
Dmitry
--- End of Original Message ---
Haven't touched it yet, I can do that this
-- Original Message ---
From: unordained unordained...@csmaster.org
To: firebird-support@yahoogroups.com
Sent: Thu, 11 Jul 2013 09:51:17 -0500
Subject: Re: [firebird-support] Re: after 2.1 to 2.5 migration, nbackup seems
to
slow operations unusually
-- Original Message
Last night, we upgraded:
SS 32-bit 2.1.5 - SS 32-bit 2.5.2(sec1), on 64-bit Windows Server 2008
For the most part, things are okay, but when nbackup is running (level-2
backups
every hour, takes about 10 minutes), I'm seeing something I haven't
historically
seen: concurrent queries take
-- Original Message ---
From: y_ongky_s ongk...@gmail.com
So the procedure work by deleting old records and then create new
records with insert command.
The problem is after records deleted from stock card table it create
garbage collection and slow down
the process when the
-- Original Message ---
From: Mahesh Pratihari mahesh.pratih...@sonata-software.com
Could you please let me know why I am getting one null row while
executing the query.
EXECUTE STATEMENT :QRYSTR
INTO
-- Original Message ---
From: peixinhosdalua peixinhosda...@yahoo.com
CREATE VIEW LISTA_CLIENTES_PESQUISA (IDCLIENTES, PESQUISA)
AS
select c.IDCLIENTES,
cp.DESCRICAO||p.NOME||c.IDCLIENTES||c.CLIENTE||c.MORADA|| c.CP||c.LOCALIDADE||
c.PAIS||c.TELEFONE||c.FAX||
c.EMAIL||
-- Original Message ---
From: K Z peixinhosda...@yahoo.com
Is there a way to make something like this:
query=where ID=10 and AGE 20;
select * from TABLE :query;
--- End of Original Message ---
create procedure filtered_select (/* parameters, preferably NOT just a text
-- Original Message ---
From: K Z peixinhosda...@yahoo.com
How can i force a failure of a write operation from inside a TRIGGER?
For example, a TRIGGER for a INSERT INTO operation. Inside the TRIGGER
i will have a IF condition and if necessary, i want to cause a failure,
-- Original Message ---
From: red_october2009 kevin.wendy.mor...@telus.net
I have the following statement:
SELECT
f.PAR_GUID,
MAX(DATEDIFF(DAY, f.EVT_DT + f.EXP_RSP_DYS, CURRENT_DATE))
FROM
JET_LTR f
WHERE
(f.EXP_RSP_DYS -1) AND
(f.RSP_RCVD_DT IS NULL) AND
-- Original Message ---
From: un_spoken brucedickin...@wp.pl
regarding option b)
b) if there's more to it, dynamically build up the EXECUTE BLOCK as you did
above, then execute the whole thing as a statement (keeping in mind that
you
need to build up a statement that
-- Original Message ---
From: hanszorn2000 hansz...@xs4all.nl
declare LOCATION integer;
declare ARTICLEID varchar(20);
BEGIN
select first 1 NEWLOCATION, ARTICLEID from ARTICLE
where ARTICLE.CUSTID = NEW.CUSTID
and ARTICLE.ISACTIVE = 'F'
-- Original Message ---
From: Ismael L. Donis Garcia ism...@citricos.co.cu
As I could validate that an alone field of varchar(11) enabled numbers
and that these had 11 characters of length?
--- End of Original Message ---
-- Original Message ---
From: un_spoken brucedickin...@wp.pl
I am pretty sure that is not possible. I've read all info I could get
on the web and it clearly says that output variables /columns must be
defined for stored procedure or execute block. But maybe I am wrong?
-- Original Message ---
From: arda atuncce...@duzen.com.tr
I have great difficulty when I need to change a stored procedure or
table structure. I receive object in use errors and can't do
anything at day time. I need to wait till about midnight and
disconnect all clients.
-- Original Message ---
From: patrick_marten patrick_mar...@yahoo.com
are there any restrictions for tables regarding field count and/or
count of fields with a certain datatype?
For instance:
would it be problematical to have a table with let's say 170 fields,
40-60 of
-- Original Message ---
From: Rick Debay rde...@accessrxs.com
I have a parent table with multiple child tables.
Each child row has a foreign key that points to one row in the parent.
Each parent row must have a child row pointing to it.
Each parent row can have only child from
-- Original Message ---
From: red_october2009 kevin.wendy.mor...@telus.net
I need an SQL statement that will return all records where at least
one human name is found in the pet names field (not the other way
around). In this case the only records that qualify are:
---
-- Original Message ---
From: Michael Ludwig mil...@gmx.de
How do you measure metadata volume? I mean, when looking at taskmgr or
ps/top/vmstat, how do you know that the memory consumption is due to
metadata and not buffers allocated for this or that?
--- End of Original
I realize this isn't official, but what I'm looking at is: http://
www.iblogmanager.com/download/misc/articles/fb25_architecture_comparison.pdf
For SuperServer, it lists SMP as available as long as the connections are
talking
to different databases, serialized if same database. This correlates
-- Original Message ---
From: Olaf Kluge olaf.kl...@satron.de
Now I have two ideas. I create a table with all fields (separate for each
information) and an import stored procedure fill this table with information
from the long string. (line_number = substring(:str_in from 1 for
-- Original Message ---
From: Dmitry Yemanov dim...@users.sourceforge.net
select 1 from bt_dchronexpl inner join bt_ref on bt_ref.file_num =
bt_dchronexpl.filenumber;
-- PLAN JOIN (BT_DCHRONEXPL NATURAL, BT_REF INDEX (IX_BT_REF_FILE_NUM_ASC))
-- so it CAN use an index, but
-- Original Message ---
From: Ann Harrison aharri...@ibphoenix.com
And what part of relational theory allows partial matches on keys.
Ann
--- End of Original Message ---
H.
Codd might disagree with the incomplete normalization of his base tables, but
relational
-- Original Message ---
From: Dmitry Yemanov dim...@users.sourceforge.net
This is known as a nested loop join. And restart from the root costs
just a couple of page reads that are likely to be satisfied using the
cache. Not something really wasteful.
2) Streams are read in
-- Original Message ---
From: kokok_kokok kokok_ko...@yahoo.es
Using FB 2.5, how can I drop a view only if it exists?
There is something like DROP VIEW IF EXISTS..?
--- End of Original Message ---
AFAIK, no such syntax. But if you're just looking for something you can
-- Original Message ---
From: Rick Debay rde...@accessrxs.com
Damn. Anyone know why the heck FB won't use an index in a join with
'starting with'? FWIW, I ran the natural part of the query to generate
a bunch of starting with 'xyx' or and appended them to query the
other
-- Original Message ---
From: nathanelrick nathanelr...@yahoo.fr
Is it possible via the api to shard a database ? I mean to split the
database in several database (this we do manually), and call the SQL
in parallele on each database and aggregate the data at the end (this
-- Original Message ---
From: nathanelrick nathanelr...@yahoo.fr
Why when i create a Primary Key that is also a foreign key 2 index are
created ? or i make a mistake somewhere ?
--- End of Original Message ---
-- Original Message ---
From: Marcin Bury marcin.b...@studio-delfi.pl
TABLE_A
ID_A - primary key
FIELD_A - some field
TABLE_B
ID_B - primary key
ID_A - reference to TABLE_A - indexed
FIELD_B - some field - also indexed
UPDATE TABLE_A
SET FIELD_A = some_value
WHERE
http://pseudotheos.com/view_object.php?object_id=1619
Maybe this is documented in Helen's book (or elsewhere?) but I haven't seen a
flow diagram yet of the exact order in which cascade rules and regular triggers
are fired. So I reverse-engineered most of it by running test scripts, but I
came
-- Original Message ---
From: unordained unordained...@csmaster.org
To: firebird-support@yahoogroups.com
Sent: Fri, 9 Sep 2011 21:52:49 -0500
Subject: [firebird-support] BLR vs. ODS
On my dev server, I thought I'd try out 2.5.1rc1, without doing a full
backup/ restore from my
33 matches
Mail list logo