Kevin,

>>I dont understand. The changes are in my local cursor.

When you're running ODBC to an external data source, the "local" cursor is actually a view that's connected to the backend db. For the most part it does look and act like a local cursor, but there are some actions that can't be performed on this cursor. To make a view a "real" local cursor you will have to alter the cursor with a SQL query:

SELECT *, .F. AS ForceLocal ;
FROM [view] ;
INTO CURSOR [local_cursor_name] READWRITE

ALTER TABLE [local_cursor_name] ;
DROP COLUMN ForceLocal

DROP TABLE [view]

At this point you now have a truly local cursor. Unfortunately it took three writes to make it happen and you will have to move the data back to the backend DB to apply any updates.

I usually reserve this for cursors where I will be making other changes to the local cursor on the workstation.

Regards,
Thom C.