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 » MySQL and Sql class issue
Re: MySQL and Sql class issue [message #6995 is a reply to message #6994] Wed, 06 December 2006 22:25 Go to previous messageGo to previous message
mirek is currently offline  mirek
Messages: 14255
Registered: November 2005
Ultimate Member
Well, constructor is about the worst place to do login Smile

It should look like this:

GUI_APP_MAIN
{
	MySqlSession session;
	if(!session.Connect("test", "welcome1", "example", "localhost")) {
		Exclamation("Can't connect with MySql\n");
		return;
	}

	SQL = session; // Use as global session

	SqlSchema sch;
	All_Tables(sch);
	if(sch.ScriptChanged(SqlSchema::UPGRADE))
		MySqlPerformScript(sch.Upgrade()); // Create schema without indexes, constraints etc...
	if(sch.ScriptChanged(SqlSchema::ATTRIBUTES)) {
		MySqlPerformScript(sch.Attributes()); // Add indexes, constraints...
	}
	if(sch.ScriptChanged(SqlSchema::CONFIG)) { // Fill with initial data if any
		MySqlPerformScript(sch.ConfigDrop());
		MySqlPerformScript(sch.Config());
	}
	sch.SaveNormal(); // Save as files for later use if needed

	SQLApp().Run();
}



Then remove "session" from MyApp and all Sql constructor leave default (sometimes you can use SQL instead of defining Sql - basicaly for all non-query statements, queries are somewhat risky )

Mirek

[Updated on: Wed, 06 December 2006 22:25]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: mysql error
Next Topic: Compiling OLEDB using MINGW
Goto Forum:
  


Current Time: Mon Apr 28 03:34:12 CEST 2025

Total time taken to generate the page: 0.00823 seconds