A CursorAdapter works similar to a view. First, you retrieve data into a cursor, than you update data in the cursor and use TABLEUPDATE() to send updates to the backend.

>It's probably a syntax problem but I can't seem to find the proper way to avoid CursorFill() to return .F. when I have an update.
>
>

>         loConnection=CREATEOBJECT('ADODB.Connection')
>         loConnection.Open(This.cSQLStringConnect)
>         loCommand=CREATEOBJECT('ADODB.Command')
>         loCursor=CREATEOBJECT('CursorAdapter')
>         loCursor.Alias=lcCursor
>         loCursor.DataSourceType='ADO'
>         loCursor.DataSource=CREATEOBJECT('ADODB.RecordSet')
>         loCursor.SelectCmd=This.cSQL
>         loCursor.DataSource.ActiveConnection=loConnection
>         loCommand.ActiveConnection=loConnection
>         IF NOT loCursor.CursorFill(.F.,.F.,0,loCommand)
>         ENDIF
>

>
>What would be the proper syntax to have an update command to be properly executed and have CursorFill() to return .T.?