missing row in a table

From: Rick Tan <rtan_at_polaris.uts.amdahl.com>
Date: 9 Mar 93 17:51:59 GMT
Message-ID: <0ezv03tBccTT00_at_amdahl.uts.amdahl.com>


I wrot e the following C program with embedded SQL

  cnt=10;
.
.

 for (i=1; i<=10; i++) {
   .
   .
   EXEC SQL INSERT INTO mytable (xyz, abc) VALUES (:xyz, :abc);  }
  EXEC SQL COMMIT WORK;
This works fine except that only 9 rows are inserted into my table. Any ideas what's happening here? If I change the loop count to 3, all three rows are inserted.

Thanks for any help.

Rick Received on Tue Mar 09 1993 - 18:51:59 CET

Original text of this message