>>>Hi,
>>>
>>>I am working on a very simple use of CA (CursorAdapter) and have a newbie question. What method of the CA do I call to send the update to the data source (SQL Server)? For example, I set values of the properties to the CA, get the cursor (calling CursorFill), change values of one or more fields of the records in the cursor. Now I want to update the SQL Server table. How? TIA.
>>
>>Tableupdate() but you need to make sure that you also set your datasource as updatable otherwise tableupdate() wouldn't do anything.
>>One simple way to get started is to use:
>>
>>
DO HOME() + "DataExplorer.app"
>>
>>and check the code generated.
>>PS: Use ADO datasource and not ODBC if you would use MS SQL.
>>
>>Cetin
>
>Thank you. Yes, I am using ADO datasource.
I forgot to say:
-Create a connection
-Open tables node
-Open a new code window (modi comm)
-Drag & drop a table from data explorer on to that code window
-Run the code that VFP has written
Cetin