CCMD is just a place holder for PK field name. I ran into this when trying to figure out how to get this to work in Oracle. How are you generating PKs in DB2?
>I changed the connection to work off Native and that appeared to work.
>
>I then tried it with DB2 (ODBC) and I get a new error.
>
>I am able to connect and insert a record. When I issue a Tableupdate() it returns false but a record is added to the DB2 table. The cursor does update the KeyID field but it always updates to the value 1.
>
>The error I get is: "The refresh key defined for table CCMD is not unique."
>I have no idea where it got the table "CCMD", I can not find it in code anywhere.
Mark McCasland
Midlothian, TX USA