>

>* cSql is defined as a "Select .... from SomeTable ...Join... into #TempTable"
>* the selection works ok, buffering is 5
>
>nSql = SQLConnect('FleetSystem')       && 1
>
>? SQLExec(nSql,cSql)                   && 1
>
>? SQLExec(nSql,[Select * From #TempTable],'Test')    && 1
>
>Delete                                 && That's all the users can do here
>
>? CursorSetProp("Tables",'#TempTable') && .T.
>
>? CursorSetProp('SendUpdates',.T.,'Sqlresult')  && .T.
>
>? CursorGetProp("Tables")              && #TempTable
>
>? TableUpdate(.t.,.t.)                 && .F.
>
>? AError(errors)                       && No update tables are specified. Use the Tables property of the cursor.
>

>
>TIA & BR

Hi Peter,

In order for TABLEUPDATE to handle Delete operations the following properties should be set:
1) Tables
2) KeyFieldList
3) UpdateNameList

The UpdateNameList property should at least include information for all fields listed in KeyFieldList.

Thanks,
Aleksey.