System.Data.SQLite

hi,

i am new at sqlite.before i used sqlserver ce.i want to create indexes and constraints,but sqlite gives errors.for example:

first i create a table;

"stok_id int NOT NULL primary key," + _

"stok_adi nvarchar(50) NOT NULL," + _

"ana_grup_adi nvarchar(25) NULL," + _

"alt_grup_ad nvarchar(25) NULL," + _

"reyon_ad nvarchar(25) NULL," + _

"fiyat3 float NULL,fiyat4 float NULL," + _

"fiyat7 float NULL,fiyat8 float NULL," + _

"birim2_ad nvarchar(10) NULL,birim2_katsayi int NULL,birim2_agirlik float NULL,birim3_ad nvarchar(10) NULL,birim3_katsayi int NULL,birim3_agirlik float NULL,toptankdv int not null,prkndekdv int not null,recno int null,dbcno int null)"

but error gives like:  '"TBL_STOK" has more than one primary key'

I am not trying to be a smart ass here but it told you what the exact error is. Get rid of one of the primary keys and make it a unique column.

http://www.sqlite.org/lang.html 

http://www.sqlite.org/lang_createtable.html 

Oh, and this page may be of some assistance to you

http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql

Search for Primary Key 

remove "primary key" from stok_id and stok_kod and add this at the end:

constraint pk_stok primary key (stok_id, stok_kod)