lcDelete = set("delete") select test set delete off scan for deleted() lcSql = textmerge("delete yourtable for pk = <<test.pk>>") ? SQLExec(nSql,lcSql) endscan set delete &lcDelete>John,
>>>* 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. >>>>>>