I have simplified my attempt to make the Oracle cursor updatable.
1. Created a test form.
2. Created a cursoradapter using the builder in the data environment of the form.
3. Ensured that the connection was working by verifing that the data was loading.
4. Tested the update by changing a single value. Tried both moving off of the record and TABLEUPDATE(.t., .t.)
5. Checked the Tables, KeyFieldList, UpdatableFieldList and UpdateNameList properties to make sure they look correct.
6. Checked the "Allows" and SendUpdates are equal to .T.
7. Tested with and without a CursorSchema
I still don't know why the data will not update.
>I have a cursoradapter that connects to my Oracle datasource and pulls the data into a cursor in a private data session. This part works fine. For some reason, it will not update the tables in Oracle.
>
>I have assigned the following properties in the INIT of the cursoradapter:
>
>Tables
>KeyFieldList
>UpdatableFieldList
>UpdateNameList
>
>SendUpdates, Allow... = .T.
>UseDeDataSource = .T.
>
>I supply the data environment object. The data environment object connects to the datasource perfectly.
>
>DataSource = ODBC
>Connection is a valid connection string...
>
>I have tested my cursoradapter object with VFP tables and it works fine; the fields update properly in the source table.
>
>Where am I going wrong?