Hi to All,

I have an Interbase table with a primary key using two table fields
defined as follow:

Create table Itemwarehouse (
ItemID varchar(32) not null,
WarehouseID varchar(32) not null,
Quantity numeric(10,3)
);

Alter Table Itemwarehouse add constraint PItemwarehouse primary key
(ItemID,WarehouseID);

Also I have a TIBOQuery component (qItemOnHand) with the following
SQL Statement:

Select ItemID, SUM(Quantity) AS OnHand
From Itemwarehouse
Where ItemID = :ItemID
Group By ItemID

I have a TDatasetProvider component linked to the TIBOQuery.

Also I have a TClientDataset linked to the TDatasetProvider
component.

The problem is, when I set the Active property to TRUE at runtime, I
obtain an exception with the following message:

"The qItemOnHand: field 'WarehouseID' not found"

I have tested it using TIBQuery (IBExpress) component and it works
fine.

I am using the following components:

Delphi 7 Enterprise Build 4.453
Interbase 6.02 (Open Source)
IBObjects 4.2.Fn
Window XP Build 2600
265MB RAM

Thanks in advanced

Gerardo Fernandez