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 » Sql global
Re: Sql global [message #6605 is a reply to message #6604] Mon, 20 November 2006 12:03 Go to previous messageGo to previous message
zsolt is currently offline  zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary
Contributor
I'm using something like these two functions to open and close sqlite database file:
void OpenDB()
{
	Sqlite3Session &sql_session = Single<Sqlite3Session>();
#ifdef _DEBUG
	sql_session.LogErrors(true);
#endif
	if(!sql_session.Open(ConfigFile("data.db"))) {
		LOG("Can't create or open database file\n");
		return;
	}
	
	// This is global:
	SQL = sql_session;
}

void CloseDB()
{
	Single<Sqlite3Session>().Close();
}


And in code I query database this way:
	Sql sql;
	sql * Select(SqlAll()).From(SOME_TABLE);
	while(sql.Fetch()){
		//Do something
		Value some_field = sql[SOME_FIELD];
	}
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: plugin/SQlite still wrong naming for linux
Next Topic: mysql error
Goto Forum:
  


Current Time: Mon Apr 28 12:09:16 CEST 2025

Total time taken to generate the page: 0.00611 seconds