>>>>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
Thank you. I will follow the steps.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham