U++ forum: Welcome to the forum

Questions about sqlite schema [message #25816]

Sat, 13 March 2010 20:07

forlano
Messages: 1185
Registered: March 2006
Location: Italy

Senior Contributor

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?

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? Can I update, select, delete data without a *.sch file?
I know that it can simplify the tasks but I do not care.

Thank you,
Luigi

[Updated on: Sat, 13 March 2010 20:08]

Report message to a moderator