U++ forum: Welcome to the forum

Re: Database with several windows [message #32959 is a reply to message #32239]

Sun, 26 June 2011 08:49

BioBytes
Messages: 310
Registered: October 2008
Location: France

Senior Member

Hi,

Try to use SqlId identifiers as global variables in your applications. It makes things easier to manage fields from different tables in the same application. For example, I use :

TABLE (NATIONS)
INT(IDNATION)PRIMARY_KEY AUTO_INCREMENT
STRING_(NATION,200)
STRING_(STATUS,50)
BLOB(FLAG)
END_TABLE

TABLE (UNITS)
INT(ID)PRIMARY_KEY AUTO_INCREMENT
INT (IDUNIT)
STRING_(UNITNAME,200)
BLOB(UNITPICTURE)
END_TABLE

TABLE (MAPS)
INT(IDMAP)PRIMARY_KEY AUTO_INCREMENT
INT(MAPNUMBER)
INT(MODULEOWNER)
STRING_(DESCRIPTION,200)
BLOB(MAPPICTURE)
END_TABLE

TABLE (MODULES)
INT(IDMODULE)PRIMARY_KEY AUTO_INCREMENT
STRING_(MODULENAME,200)
STRING_(EDITOR,200)
END_TABLE

and the SqlId:

SqlId TBLMAPS("MAPS"),TBLNATIONS("NATIONS"),TBLUNITS("UNITS"),TBLMODULES( "MODULES"),IDNATION("IDNATION"),
ID("ID"),IDMOD("IDMODULE"),IDUNIT("IDUNIT"),UNIT("UNITNAME "),IDM("IDMAP"),NUMBER("MAPNUMBER"),
MAPIMG("MAPPICTURE"),UNITIMAGE("UNITPICTURE"),OWNER("MODULEOWNER "),DESC("DESCRIPTION"),FLAG("FLAG"),
STATUT("STATUS"),NAME("NATION"),MODULE("MODULENAME"),EDITORMOD( "EDITOR"),ALL("*");

Sqlite3Session ASLDBSession;

Hoping this could be helpful

Regards

Biobytes

Report message to a moderator