U++ forum: Welcome to the forum

Create Table with Sqlite [message #12238]

Sat, 20 October 2007 12:40

Alex
Messages: 18
Registered: October 2007
Location: Germany

Promising Member

Hi,
I work for a few months with upp and now I have a problem with sqlite:

Sql sqlVer;
Sql sqlRaum;
Sql sqlNew;
	
sqlVer * Select(RAUMID).From(VERANST).Where(VID == id);
sqlRaum * Select(SEKTION,REIHE,PLATZ,PREISGR,XDISPL,YDISPL,COLDISPL).From(RAUMPLAN).Where(RNR == sqlVer[RAUMID]);
String TableName = Format("%08d",id);

String s = "CREATE TABLE V" + TableName; 
	s += " (ID integer primary key autoincrement , SEKTION integer, REIHE integer,";
	s += " PLATZ integer, PREISGR integer, XDISPL integer, YDISPL integer, COLDISPL integer)";

sqlNew.Execute(s);

Generates a error:

ERROR SQL logic error or missing database(0): CREATE TABLE V00000013 (ID integer primary key autoincrement , SEKTION integer, REIHE integer, PLATZ integer, PREISGR integer, XDISPL integer, YDISPL integer, COLDISPL integer)
ERROR database table is locked(0): Resetting statement: CREATE TABLE V00000013 (ID integer primary key autoincrement , SEKTION integer, REIHE integer, PLATZ integer, PREISGR integer, XDISPL integer, YDISPL integer, COLDISPL integer)

Can someone please tell me what is wrong here.

Thanks in advance,

Alex

Report message to a moderator