is it possible to completely delete a datarow with a single command if so which one?
- Code: Select all Expand view
LOCAL oRsDel AS OBJECT
LOCAL cSql AS CHARCTER
cSql := ""
cSql += "SELECT *" + " "
cSql += "FROM " + ::cTabellaTestate + " "
cSql += "WHERE " + ::cCampoFiltro + " >= ? AND "
cSql += ::cCampoFiltro + " <= ?"
::oRsDel := ::oCn:RowSet( cSql, { ::uValDa, ::uValA } )
::oRsDel:deleteall()
*- or only method is
::oRsDel:gotop()
do while .not. ::oRsDel:eof()
::oRsDel:delete()
::oRsDel:skip()
enddo