Home » U++ Library support » U++ SQL » Questions about sqlite schema
Questions about sqlite schema [message #25816] |
Sat, 13 March 2010 20:07 |
|
forlano
Messages: 1202 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
|
|
|
Re: Questions about sqlite schema [message #26038 is a reply to message #25816] |
Fri, 26 March 2010 18:20 |
|
mirek
Messages: 14039 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?
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.
|
|
|
|
|
Goto Forum:
Current Time: Sat Sep 21 02:53:42 CEST 2024
Total time taken to generate the page: 0.04408 seconds
|