Subject Re: [firebird-support] COMPUTED BY by SELECT correct, but identical SP incorrect (bug?)
Author Raymond Kennington
Raymond Kennington wrote:
I found the problem. ID is also a fieldname in the detail table and I should
have used a colon in the WHERE clause.

SELECT SUM (FD."Quantity Disposed")
FROM "Feed Disposed" FD
WHERE FD."Inventory Location ID" = :ID <----
INTO "Total Disposed";
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)