U++ framework: U++ SQL » Questions about sqlite schema

Home » U++ Library support » U++ SQL » Questions about sqlite schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Fri, 26 March 2010 23:22

forlano
Messages: 1221
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

[Message index]

		Questions about sqlite schema By: forlano on Sat, 13 March 2010 20:07
		Re: Questions about sqlite schema By: mirek on Fri, 26 March 2010 18:20
		Re: Questions about sqlite schema By: forlano on Fri, 26 March 2010 23:22
		Re: Questions about sqlite schema By: mirek on Fri, 02 April 2010 10:48

Previous Topic:	sqlite busy/lock timeout patch
Next Topic:	Any way to generate sch from database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Apr 29 05:41:05 GMT+2 2026

Total time taken to generate the page: 0.00583 seconds