Dear friends,
Opening the table RDB$TRIGGERS, I saw many rows where the column
RDB$TRIGGER_SOURCE is empty (null or an empty string). And the related tables
doesn´t present these triggers.
I ask you:
-Are these rows at RDB$TRIGGERS useless ?
-May I delete these rows ?
-If I delete these
Dear Mark,
Thanks a lot for your quick answer. I suspected this, specially because the
column rdb$system_flag is different of 0 (zero). But as I don't know deeply the
bd structure (the system tables), I asked this for to know if this case could
mean useless triggers, and then this could mean
Hi everyone,
Can someone please advise me as to what is happing with this SQL Select
statement I am trying to use
SQLCommand = vbNullString
SQLCommand = SQLCommand SELECT
SQLCommand = SQLCommand PRODUCTCODE,
SQLCommand = SQLCommand PRODUCTDESCRIPTION,
SQLCommand
GROUP BY PRODUCTDESCRIPTION there is PRODUCTCODE missing here
if you use aggregate functions u have to add all fields to GROUP BY that are
not used with aggregate functions
From: Andrew gable andrew.ga...@tesco.net
To: firebird-support@yahoogroups.com
Sent:
I am sorry I Really do not understand :(
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Nagy Szilveszter
Sent: 15 June 2013 5:57 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Help on this SQL
The problem is that you have asked to summarize the data by grouping on
product description but you have also asked for a product code. The server
does not know if there is a one-to-one relationship between product
description and product code. Therefore, it does not know what product code
to use
Change it into this syntax:
SQLCommand = vbNullString
SQLCommand = SQLCommand SELECT
SQLCommand = SQLCommand PRODUCTCODE,
SQLCommand = SQLCommand PRODUCTDESCRIPTION,
SQLCommand = SQLCommand SUM(PRODUCTQTY),
SQLCommand = SQLCommand SUM(PRODUCTTOTAL)
SQLCommand = SQLCommand From
Something more, generally it is a better practice to have a view and call
that view.
So, you would write: SELECT * FROM MyView WHERE MyCondition GROUP BY
MyColumns ORDER BY MyOrder
Greetings.
Walter.
On Sat, Jun 15, 2013 at 3:54 PM, Iwan Cahyadi Sugeng
iwan.c.sug...@gmail.com wrote:
Em 15/6/2013 16:54, Iwan Cahyadi Sugeng escreveu:
Change it into this syntax:
SQLCommand = vbNullString
SQLCommand = SQLCommand SELECT
SQLCommand = SQLCommand PRODUCTCODE,
SQLCommand = SQLCommand PRODUCTDESCRIPTION,
SQLCommand = SQLCommand SUM(PRODUCTQTY),
SQLCommand = SQLCommand