System.Data.SQLite

Hi, I know you have heard this before, but Thank you Thank you Thank you!

Anyone of you had problems with boolean fields in query builder? I made a table with a boolean field, created a simple SQLiteConnection and a SQLiteCommand. When I clicked "..." in the CommandText property and added the table to the querybuilder, it stopped showing the fields when it found the boolean field. Could it have something to do with naming conventions (bit/boolean)?

Thank you again! :)

What was the table definition exactly?

It was very simple, something like:

id, INTEGER, Primary key
questionId, INTEGER
correct, BOOLEAN
answer, TEXT

The table shown in the querybuilder stopped before the boolean field. Try moving it up and down in the table and it will show less and more fields.

If you cannot reproduce it, I'll give you the exact structure. Thanks for helping out!

Give me the exact table definition so I can be sure it's resolved.

Robert

CREATE TABLE [answer] (
[id] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,
[questionId] INTEGER  NOT NULL,
[answer] TEXT  NULL,
[correct] BOOLEAN  NULL,
[started] TIME  NULL
)

Hello, 

Same Problem here with VS2005 Express C#. In the Query Builder, no more field appears in the table view.

Did you find a solution ?

(version 1.0.46)

http://img228.imageshack.us/img228/2015/view3yo2.png

http://img215.imageshack.us/img215/2451/view1pf9.png

http://img265.imageshack.us/img265/9457/view2oh1.png 

Thanks.