| Subject | Re: [firebird-support] COMPUTED BY by SELECT correct, but identical SP incorrect (bug?) |
|---|---|
| Author | Raymond Kennington |
| Post date | 2003-07-13T04:27:04Z |
Raymond Kennington wrote:
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)
>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)