clear a table

[Desaster]

hello,

I have a table in SQLite database how to clear it every weak ?

[xXMADEXx]

You can just check the date..something like this, although this code hasn't been tested

local nextClearDate = { } 
function checkDate ( ) 
    local t = getRealTime ( ) 
    local day = t['monthday'] 
    local month = t['month']+1 
    local year = t['year'] + 1900 
    if ( #nextClearDate <= 0 ) then 
        nextClearDate = {  
            day = day, 
            month = month, 
            year = year 
        } 
    end 
    if ( nextClearDate.year < year )then 
        executeClear ( ) 
    end 
    if ( nextClearDate.month < month ) then 
        executeClear ( ) 
    end 
    if ( nextClearDate.day < day and nextClearDate.month <= month ) then 
        executeClear ( ) 
    end 
end 
setTimer ( checkDate, 600000, 0 ) 
  
function executeClear ( ) 
    dbQuery ( databaseconnection, "DELETE FROM TableName" )  
    local t = getRealTime ( ) 
    local day = t['monthday'] 
    local month = t['month']+1 
    local year = t['year'] + 1900 
    nextClearDate.day = nextClearDate.day + 7 
    if ( nextClearDate.day > 30 ) then 
        nextClearDate.day = 1 
        nextClearDate.month = nextClearDate.month + 1 
    end 
    if ( nextClearDate.month > 12 ) then 
        nextClearDate.year = nextClearDate.year + 1 
        nextClearDate.month = 1 
    end 
end 
  
  

Edited November 17, 2013 by Guest

[Renkon]

it's not DELETE * FROM table

its DELETE FROM table

[Desaster]

renkon what you sayed is to delte a part of the table I need to delte the whole table Content thnx xXMADEXx

[Renkon]

Using DELETE FROM table removes all