Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Issue with getting data back from a sqlite3 database
Issue with getting data back from a sqlite3 database [message #19644] Sat, 27 December 2008 13:48 Go to previous message
BioBytes is currently offline  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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Convert String to SqlId
Next Topic: How to use Sql * Update
Goto Forum:
  


Current Time: Tue Jun 24 18:10:38 CEST 2025

Total time taken to generate the page: 0.03702 seconds