U++ framework: U++ SQL » Issue with getting data back from a sqlite3 database

Home » U++ Library support » U++ SQL » Issue with getting data back from a sqlite3 database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Sat, 27 December 2008 13:48

BioBytes
Messages: 312
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

Re: Issue with getting data back from a sqlite3 database [message #19647 is a reply to message #19644]

Sat, 27 December 2008 23:42

zsolt
Messages: 705
Registered: December 2005
Location: Budapest, Hungary

Contributor

You have to call sql.Fetch() first, I think.

BTW, why don't you use Upp way to handle your database?

Report message to a moderator

Re: Issue with getting data back from a sqlite3 database [message #19648 is a reply to message #19647]

Sun, 28 December 2008 09:22

BioBytes
Messages: 312
Registered: October 2008
Location: France

Senior Member

Thank you for your advice,

I still got an error "assertion failed : NULL != stmt". I think the syntax of my sql query is not correct. When I check if the base is open, I get true response as well as false when I close the sqlite file "DeepSkyDB".

Please what do you mean by UPP way ? I am a newbie for connecting databases with UPP.

Thanks for your reply

Kind regards
Biobytes

Report message to a moderator