U++ forum: Welcome to the forum

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

Fri, 26 March 2010 23:22

forlano
Messages: 1185
Registered: March 2006
Location: Italy

Senior Contributor

luzr wrote on Fri, 26 March 2010 18:20

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

Hello,

because using sqlitebrowser I can import without problem a cvs file exported by MySql with phpmyadmin. If I mix the column order a mismmatch occur and I need to prepare my own import routine.

Luigi

Report message to a moderator