I go into the cursor itself and change the value of one of the fields, then move off of the record or execute a TABLEUPDATE(.t., .t.) in the command window. I have set a "SET STEP ON" in the init of the test form. This test works correctly with VFP tables.


I have other code available to me which creates custom views that are dependant on the database container. These views update the source tables correctly as well when changing the values in the cursor.

I want to convert my views over to cursoradapters instead.


I have tested a manual update of one of the Oracle records and I do have the correct access rights.



>?
>Can you post the code where you updating CA?
>
>>TABLEUPDATE(.t., .t.) results in .T.
>>AERROR(a_Error) results is 0 (no error)
>>
>>Executing the code again shows that the record has not been updated.
>>
>>
>>
>>>>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?
>>>
>>>And what is the result of TableUpdate?
>>>And if it is .f. what AERROR() gives you as info?