U++ forum: Welcome to the forum

Re: Sql crash in 64 bit machine [message #36572 is a reply to message #36569]

Sun, 10 June 2012 18:08

forlano
Messages: 1207
Registered: March 2006
Location: Italy

Senior Contributor

mirek wrote on Sun, 10 June 2012 10:39

No, 32-bit executables run in 64-bit windows just fine, there should be no difference.

Thanks.
I thought and hoped the same. In 32 bit the program is stable and do not crash. In 64 bit it does not work at the very beginning when the database is created.
The log file consists of rows similar to these:

* F:\orion\orion.exe 09.06.2012 19:56:30, user: User

SQL* create table TORNEO (  ID integer primary key )
ERROR library routine called out of sequence(0): Preparing: create table TORNEO (  ID integer primary key )
SQL* alter table TORNEO add  NAME text
ERROR library routine called out of sequence(0): Preparing: alter table TORNEO add  NAME text
SQL* alter table TORNEO add  PLACE text
ERROR library routine called out of sequence(0): Preparing: alter table TORNEO add  PLACE text
SQL* alter table TORNEO add  HOSTFED text
ERROR library routine called out of sequence(0): Preparing: alter table TORNEO add  HOSTFED text
SQL* alter table TORNEO add  DATEB text
ERROR library routine called out of sequence(0): Preparing: alter table TORNEO add  DATEB text
SQL* alter table TORNEO add  DATEE text
ERROR library routine called out of sequence(0): Preparing: alter table TORNEO add  DATEE text
SQL* alter table TORNEO add  PARBITER text
ERROR library routine called out of sequence(0): Preparing: alter table TORNEO add  PARBITER text
SQL* alter table TORNEO add  DARBITER text

and this is the code that create it

void vegadb::SetDatabase(String dbname)
{
    if (sqliteVT.IsOpen()) sqliteVT.Close();
//	if(!sqliteVT.Open(ConfigFile(dbname))) {
    if (!FileExists(dbname)) {
		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 {
		if(!sqliteVT.Open( dbname )) {
			Exclamation("Can't create or open database file");
			return;
		}
		SQL = sqliteVT;
		sqliteVT.SetTrace();
		SqlSchema sch(SQLITE3);
	}
	SQL.ClearError();
}

I am sure these info are not enough to catch the problem, but maybe somebody got a similar problem.
Luigi

Report message to a moderator