Hello guys,
while programming a database I ran into a problem with some SQL-Queries. SqliteConnection conn = new SqliteConnection("data source = " + pathtoDB);

            SqliteCommand selectMaxValue = new SqliteCommand();
            selectMaxValue.Connection = conn;
            selectMaxValue.CommandText = "SELECT myValue FROM myTable;";

            conn.Open();

            SqliteDataReader reader = selectMaxValue.ExecuteReader();
            while (reader.Read())
            {
                int maxValue = int.Parse(reader["myValue"].ToString());
                Console.WriteLine(maxValue);
            }

            conn.Close();

This code gives me the values I want. But if I change the Query to "SELECT MAX(myValue) FROM myTable;" or "SELECT myValue FROM myTable WHERE 'something'" the result in reader is empty.
If I try the queries in a shell it works just fine (so nothing wrong with my database).
Why is it that I can't run other queries?
Thanks in advance

Because you are asking for the value of something called "myValue" and the other query's do not return anything called "myValue". Try something like:

select max(myValue) AS myValue from myTable;

If you want to access the result using the name "myValue" ...

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"]).

This makes perfect sense and if not for now I would have run into that problem later, but my error occures in this SqliteDataReader reader = selectMaxValue.ExecuteReader(); line. While in Debug-Mode I read the value of "reader" after the statement above.

Since the default column name is "max(myValue)" perhaps the wrapper pukes on it. Did you try explicitly naming the column to something using an AS clause?

Yes, I tried. Still empty.
What do you mean by "pukes on it"? In which way could the wrapper affect my situation?

For example, I have a wrapper that uses the returned column names to form object attribute names. Attribute names must start with an alphabetic character or underscore, and may contain only alphanumerics and underscores. So a SQL statement such as select max(y) from x will return a single column of results with the name max(y). If you attempted to use this as an attribute name, explosions would occur.

I don't know what you are using to access the returned data so perhaps it does not "like" the parenthesis and just drops the data silently rather than failing quickly and loudly.