[RBASE-L] - Update -- NOT

[Jim Limburg]

Could someone fill me in on what I'm doing wrong here..

DROP VIEW invsmrize
CREATE VIEW invsmrize (category, ctotals ) +
AS SELECT category, SUM(cy_unit_cost * quantity) FROM tmdinv +
GROUP BY category

UPDATE lycopy03 SET totalamt = (T2.ctotals) FROM tmdinv T1, invsmrize T2 +
WHERE T1.category = T2.category

I am creating the view above to gather some totals, and then I just
want to update a column in a table with the results. The lycopy03 table
has just two columns Category (Text 15) and totalamt which is currency.
The tmdinv table has several columns but the Category is Text 15, the
cy_unit_cost is double and the quantity is real. In my view I get some
ugly results, and I'm wondering if this is the culprit here.

Any help appreciated.

Jim Limburg