Home » U++ Library support » U++ SQL » Create Table with Sqlite
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
|
|
|
Goto Forum:
Current Time: Fri May 03 13:43:03 CEST 2024
Total time taken to generate the page: 0.02801 seconds
|