U++ forum: Welcome to the forum

Re: Questions about sqlite schema [message #26038 is a reply to message #25816]

Fri, 26 March 2010 18:20

mirek
Messages: 13976
Registered: November 2005

Ultimate Member

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?

I am afraid yes. Why do not you want it to be first? Smile

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?

No, you do not.

Quote:

Can I update, select, delete data without a *.sch file?
I know that it can simplify the tasks but I do not care.

Yes. You might need to define some SqlIds if you want to use SqlExp. And you cannot use S_* structures to fetch whole records.

But other than that, of course, you do no need .sch. .sch is just extension/option.

Report message to a moderator