SQLite Forum

how to refuse write empty value
Login
> IF (%val2%)==() goto HellFrozeOver
> ...
> 
> :HellFrozeOver
> echo ERROR!  Hell Froze Over and val2 is empty

```
      REM (and K. Medcalf discovered teaching BATCH programming 101. ;-)
```

Can you imagine writing SQL injection defense so that cmd.exe can run it?

To the OP:

With some care, you could get recent versions of the SQLite shell to run parameterized queries and stuff in the values that made their way into and out of your batch script.  See .help for the .parameter command.