Can I create a cursor and then insert records into it?
I have creted a cursor so far by asking for top 1 record. The problem is that the update command gets confused even though I don't modify that row, but only insert additional rows.

Do I have to have a unique key in the target table if I want to use a cursor adaptor to insert multiple rows?

I have worked on this for a while. I have no problem in getting cursors from tables, updateing them with changes and saving the changes. I am using a simple program version of a cursoradaptor and manually setting my update and insert commands.

Any help would be appreciated.

Fred