At 12:22 AM 26/08/2004 +0000, Steve Harp wrote:

>procedure TDMFb.UpdateAveIdealUsage(const sItem : String);
>Var
> iInvItemID : Integer;
> qry : TIB_Query; <---- You said TIB_Cursor previously
>Begin
> iInvItemID := DMFb.GetInvItemID(sItem);
> if (iInvItemID <> 0) then
> Begin
> qry := TIB_Query.Create(Self);
> Try
> qry.IB_Connection := conIx;
> qry.IB_Transaction := trnIx;
> qry.DatabaseName := 'IxFB';
> qry.SQL.Add('Select QtySold From xItemUsages');
> qry.SQL.Add('Where InvItemID = ' + IntToStr(iInvItemID));
> qry.Open;
> qry.First; <------ for TIB_Cursor, not TIB_Query

....

I'd be more interested to see the source for the SP...

Helen