>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?
Technically, you do not have to have a PK to insert new records. HOWEVER, if you are using a CursorAdapter to insert these records [or do any data updating of any kind], then you will need to specify the KeyFieldList, UpdatableFieldList and UpdateNameList properties.
>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
Mark McCasland
Midlothian, TX USA