Android Question Sqlite Text fields

[TomDuncan]

Hi all,
I have created a sqlite database with this definition
DROP TABLE IF EXISTS books;
CREATE TABLE books (
ID Integer Primary Key,
Author VARCHAR(100),
BookName VARCHAR(100),
AndroidPath VARCHAR(100),
Desc TEXT,
BookTitle VARCHAR(100),
lang VARCHAR(20),
Subject VARCHAR(20));

All works well until I try and load the Desc (TEXT) field into a label.
I get an error saying it cannot read a blob field.
This is not a blob but a text field.
Can I declare Cur.GetString("Desc") as a text string or what can I do.
Thanks in Advance

Tom

 

[Erel]

See my answer to your question here: http://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/page-2#post-196737

 

[TomDuncan]

Thanks for that, all fixed.
I lost a lot of my old data due to a drive crash a few months ago.
So just learning all over again.
Tom