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

[Message index]

		Issue with getting data back from a sqlite3 database By: BioBytes on Sat, 27 December 2008 13:48
		Re: Issue with getting data back from a sqlite3 database By: zsolt on Sat, 27 December 2008 23:42
		Re: Issue with getting data back from a sqlite3 database By: BioBytes on Sun, 28 December 2008 09:22
		Re: Issue with getting data back from a sqlite3 database By: zsolt on Sun, 28 December 2008 10:49
		Re: Issue with getting data back from a sqlite3 database By: BioBytes on Sun, 28 December 2008 18:24

Previous Topic:	Convert String to SqlId
Next Topic:	How to use Sql * Update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 05 03:42:33 GMT+1 2026

Total time taken to generate the page: 0.00581 seconds