TABLE_(DBELO) STRING (NOME, 35) INT_ (ELO) STRING_ (CAT, 4) INT_ (K) STRING (SIGLAPROV, 2) DATE_ (DATA) INT_ (IDFIDE) INT_ (IDFSI) PRIMARY_KEY STRING_ (SEX, 1) END_TABLE
TABLE_(DBELO) STRING (NOME, 35) INT_ (ELO) STRING_ (CAT, 4) INT_ (K) STRING (SIGLAPROV, 2) DATE_ (DATA) INT_ (IDFIDE) INT_ (IDFSI) PRIMARY_KEY STRING_ (SEX, 1) END_TABLE
Quote: |
2) I have used the Firefox plugin SQLite Manager to import the data (csv file) from MySql into Sqlite database. Now I am going to write the Upp code to perform some operation. The question is: Do I need a schema file in order to work with a sqlite database? |
Quote: |
Can I update, select, delete data without a *.sch file? I know that it can simplify the tasks but I do not care. |
forlano wrote on Sat, 13 March 2010 14:07 |
Hello, I am trying to replicate an application written in PHP+MySql with Upp+Sqlite. I jave two questions. 1) With the following table I have problem at runtime TABLE_(DBELO) STRING (NOME, 35) INT_ (ELO) STRING_ (CAT, 4) INT_ (K) STRING (SIGLAPROV, 2) DATE_ (DATA) INT_ (IDFIDE) INT_ (IDFSI) PRIMARY_KEY STRING_ (SEX, 1) END_TABLE ERROR Cannot add a PRIMARY KEY column(0): Preparing: alter table DBELO add IDFSI integer primary key The problem disappear if I move the field INT_ (IDFSI) PRIMARY_KEY at the top of declaration. Is it normal? |