Your problem is the line where you explicitly says that you want to have one
line returned for each combination of HORA, PRODUTO and DATAB in TABELAB:
GROUP BY HORA, PRODUTO, DATAB
The simplest solutions is probably either to change your group by to
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8
or to use
userClause is probably null. Then the entire string will be null.
Am 25.06.2014 16:08, schrieb Tim Ward t...@telensa.com [firebird-support]:
Anyone know what this error message actually means?
Yes I am trying to run an EXECUTE STATEMENT, but it's not clear to me
what an argument means
In fact it was elementid.
My problem was how long it took me to guess what the error message meant
(I didn't find it in the FAQ of what error messages mean?). Wording like
You can't EXECUTE STATEMENT a NULL, it has to be a string would have
been immediately clear.
On 26/06/2014 12:58, Thomas
CREATE PROCEDURE PRODS(PAC INTEGER)
RETURNS(
HOR TYPE OF HORA,
SEG TYPE OF DESCRICAO,
TER TYPE OF DESCRICAO,
QUA TYPE OF DESCRICAO,
QUI TYPE OF DESCRICAO,
SEX TYPE OF DESCRICAO,
SAB TYPE OF DESCRICAO,
DOM TYPE OF DESCRICAO)
AS
BEGIN
FOR SELECT DISTINCT HORA,
My problem was how long it took me to guess what the error message
meant (I didn't find it in the FAQ of what error messages mean?). Wording
like You can't EXECUTE STATEMENT a NULL, it has to be a string would have
been immediately clear.
A better message would really be appropriate.
You
Hello,
We are in the processes of migrating to a new server for our database.
Currently we are using Firebird 2.1 Classic with Ubuntu 8.04 and are upgrading
to Firebird 2.5.2 SuperClassic with Ubuntu 14.04.
In our current database, when viewing the attachment monitoring table using