| Subject | NEED HELP... (TROUBLE WITH IB_QUERY) |
|---|---|
| Author | Alessandro Corona |
| Post date | 2000-11-20T07:51:01Z |
Hi
In my program I try to use the follow SQL
statement with IB_Query:
--------------------------------
SELECT IDUSER,SUM(ORE)
FROM ORE
GROUP BY IDUSER;
--------------------------------
all
seems ok ,but after I have activated the IB_Query (Object
Inspector)
when I
try to open the Dataset I get this message error:
"
Fieldname: not found "
The
table ORE is declared as following:
-----------------------------------------------------
/* Table: ORE, Owner: CORONA
*/
CREATE TABLE "ORE"
(
"PROGRESSIVO" INTEGER NOT
NULL,
"N_COMMESSA" INTEGER NOT
NULL,
"DESCRIZIONE" VARCHAR(60) NOT
NULL,
"ORE" SMALLINT NOT NULL,
"IDUSER" VARCHAR(20) NOT
NULL,
"DATATT" TIMESTAMP NOT
NULL,
PRIMARY KEY
("PROGRESSIVO")
);
-----------------------------------------------------
Help me,
Thanks
in advance.
Alessandro Corona
icq n. 59864836