Yes, that's pretty much what I figured out after fooling around with it for a while. Seems a bit silly, but what the hell...

Thank you for your help.

BR

Peter


>According to the help: "You must include a list of fields for updates to work"
>
>
>
>
>>John,
>>
>>Maybe, but I don't want to, 'cause all the users are supposed to do is delete records.
>>
>>So, must I?
>>
>>
>>>Don't you need to specify the updatefieldlist?
>>>
>>>
>>>
>>>
>>>>

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