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