SQLite Forum

SQL-Query is always empty
Login
When you run your queries outside of your program, in any database viewer or the CLI, note the column name at the top of the list of values - THAT is the value name that sqlite (or any SQL engine) returns, and THAT is the name your (reader["somevalue"]) will be reading.

To prove this, change the query to:

```
  SELECT myValue AS Cowabunga FROM myTable;
```

Your original code will now also not work, but then change your code to:

```
  ....parse(reader["Cowabunga"])
```
et voila, it will work again because now the returned data column name and the request name match again.

When you request data by name, make sure you use (SELECT ... AS xxx FROM ...) where you read data like (reader["xxx"]).