lundi 20 avril 2015

Batch cant get value in if statement

setlocal enabledelayedexpansion
    set "count=SELECT COUNT(*) FROM Events;| sqlite3.exe system_events"
    echo %count% 
    set "sk=1000"
    if %count% gtr %sk% (
        echo Delete from Events where Id IN ( Select Id from Events limit 1^) ;| sqlite3.exe system_events" 
        pause
    )
    set "laik=%time:~0,2%:%time:~3,2%:%time:~6,2%"
    echo INSERT INTO Events (Date, Time, Error_type) Values ("%Date%", "%laikas%", 0);| sqlite3.exe system_events

I have this problem, in %count% variable I get number of records of database, in echo it works fine it outputs number like 132, but in if statement I can see IF is comparing not 132 but

>if SELECT COUNT(*) FROM Events;|sqlite3.exesystem_even
ts gtr 1000 (

And in that way IF statement is not working, wheres my problem? :) thanks :)

Aucun commentaire:

Enregistrer un commentaire