Here is a further test:
------------------------------------------------------
BEGIN WORK;
DECLARE cursor1 CURSOR FOR SELECT * FROM PARTS;
FETCH FIRST IN cursor1;
INSERT INTO partstemp VALUES (PARTS.QTY, PARTS.LENGTH, PARTS.WIDTH);
CLOSE cursor1;
COMMIT WORK;
------------------------------------------------------
What I get is the whole table put into partstemp. I just wanted the
one row???
One more question what is the difference between using the term IN vs.
FROM?