SQLite doesn't return what it should return

Question

Everything works fine, except one thing. When i try to pull the username of the one with the highest score, the program fails.

The result that i get is 0 instead of le_user

This is the part of code that act's weird:

string query = "SELECT * FROM \"Highscore_List\" ORDER BY Highscore_List.score DESC LIMIT 1";
DataTable  recipe = db.GetDataTable(query);
foreach (DataRow r in recipe.Rows)
{
    string old_user = r["user_name"].ToString();
    int oude_topscore = Convert.ToInt32(r["score"]);
}

And the score is right, just the user name not. And when i leave this part of the query

ORDER BY Highscore_List.score DESC LIMIT 1

The result is still the same. So that isn't the problem.

So what am I doing wrong?

EDIT:

Here is an SQL dump of it:

-- ----------------------------
-- Table structure for "main"."Highscore_List"
-- ----------------------------
DROP TABLE "main"."Highscore_List";
CREATE TABLE "Highscore_List" (
"id"  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"score"  INTEGER NOT NULL,
"user_name"  INTEGER NOT NULL
);

-- ----------------------------
-- Records of Highscore_List
-- ----------------------------
INSERT INTO "main"."Highscore_List" VALUES (1, 1, 'hui');
INSERT INTO "main"."Highscore_List" VALUES (2, 2, 'Onbekend');
INSERT INTO "main"."Highscore_List" VALUES (3, 3, 'onbekend_tt');
INSERT INTO "main"."Highscore_List" VALUES (4, 2, 'onbekenddd');
INSERT INTO "main"."Highscore_List" VALUES (5, 6, 'le_user');
INSERT INTO "main"."Highscore_List" VALUES (6, 0, 'Onbekend');

Then it would suggest that the data in your table isnt what you thought. — BugFinder
– BugFinder, Commented Sep 12, 2012 at 13:57
@BugFinder, i've updated the question, so you can see that the table is what i tink. And when i change the number of highscore, the number at the program will change to... — Mathlight
– Mathlight, Commented Sep 12, 2012 at 14:01
What does "And when i change the number of highscore, the number at the program will change to" mean? I dont understand that, are you updating highscore in your db? — BugFinder
– BugFinder, Commented Sep 12, 2012 at 14:03
Yup, i have navicat (prog to admin datases) and with that, i update the number to check if the program works... — Mathlight
– Mathlight, Commented Sep 12, 2012 at 14:04
OK, but does your code work before you change values? No chance the drop isnt working? — BugFinder
– BugFinder, Commented Sep 12, 2012 at 14:11

Stephan · Accepted Answer · 2012-09-12 14:27:00Z

1

You have created your column "user_name" as an integer column.

Actually, it is ok for SQLite to put text values into an integer column and read it out again as text. However, I'm not familiar with the ADO.NET interface to SQLite. It seems that it reads out "user_name" values as integer which results in the 0 values. I see two ways to solve the problem:

Create the "user_name" column as TEXT
Find a way to tell the ADO.NET-SQLite-bridge that it should interpret the values in the "user_name" column of query results as TEXT

answered Sep 12, 2012 at 14:27

Stephan

4,2431 gold badge23 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite doesn't return what it should return

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related