That was overwhelming - thank you all for your help.

BR

Peter

>>

>>* 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.