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? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
