Simple one. Change your SQL to something like

SELECT IDUSER,SUM(ORE) AS ORESUM
FROM ORE
GROUP BY IDUSER;

Set

At 08:51 20.11.2000 +0100, you wrote:

>>>>

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
<mailto:corona@...>corona@...
icq n. 59864836








eGroups Sponsor
<http://click.egroups.com/1/9667/3/_/685810/_/974707660/>

<<<<