extern	Sqlite3Session sqliteVT; // sqliteVT is defined as a global variable

void vegadb::SetDatabase(String dbname)
{   //close a database already opened
    if (sqliteVT.IsOpen()) sqliteVT.Close();
    
    if (!FileExists(dbname)) {
        //create database 
		if(!sqliteVT.Open( dbname )) {
			Exclamation("Can't create or open database file");
			return;
		}
		SQL = sqliteVT;
		sqliteVT.SetTrace();
		SqlSchema sch(SQLITE3);
		All_Tables(sch);
		Sqlite3PerformScript(sch.Upgrade());
		Sqlite3PerformScript(sch.Attributes());  		
	}
	else {
		//read database
		if(!sqliteVT.Open( dbname )) {
			Exclamation("Can't open database file");
			return;
		}
		SQL = sqliteVT;
		sqliteVT.SetTrace();  	

	}
	SQL.ClearError();
}

void vegadb::GetPlayersDBData()
{   VPlayer.Clear();	
    SQL.Execute("SELECT * FROM PLAYERS ORDER BY ID ASC, BOARD ASC");
    while(SQL.Fetch()) {
	Player& p = VPlayer.Add( (int) SQL[ID] );
	p.player_id = (int) SQL[ID];
        p.team_id = (int) SQL[TEAM_ID];
        p.board = (int) SQL[BOARD];  
        p.name = (String) SQL[NAME];  
        p.codetitle = (String) SQL[CAT]; 
        p.title = p.TitleToCode(); //convert string to number
        p.federation = (String) SQL[FED];  
        p.data = (String) SQL[BDAY];  
		p.sex = (String) SQL[SEX];  
		p.idfide = (int) SQL[IDFIDE];  
		p.ratingfide = (int) SQL[RTGFIDE];  
		p.idnat = (String) SQL[IDNAT];  
		p.ratingnat = (int) SQL[RTGNAT];  
		p.kcoeff = (int) SQL[K];  	
	}
}