U++ forum: Welcome to the forum

Issue with getting data back from a sqlite3 database [message #19644]

Sat, 27 December 2008 13:48

BioBytes
Messages: 310
Registered: October 2008
Location: France

Senior Member

Hi all,

I wrote the following code which works when oepning and closing the sqllite3 database file :

if(deepSkySession.Open("deepSkyDB")){
deepMessageLbl.SetText("En consultation");
Sql sql(deepSkySession);
sql.Clear();

sql.Execute("select * from deepskygendata");

PromptOK(AsString(sql.GetColumns()));
}
else PromptOK("Impossible d'ouvrir la base de donn�es");
}

but I did not recover data information as sql.getcolumns() returned 0.

I have built my database using Sqliteman software and when I built the query through Sqliteman I got the following syntax :

SELECT CONSNAME FROM "main"."deepskygendata";

How can I write the sql.execute(String str)so it goes right ?

Thanks in advance for help

Regards
Biobytes

Report message to a moderator