primary key declaration error while creating table

Question

CreateL()
{
_LIT(KSQLCountry, "CREATE TABLE Country(CountryID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,CountryName VARCHAR(45) NOT NULL,CountryCode VARCHAR(10) NOT NULL)");
User::LeaveIfError(iDatabase.Execute(KSQLCountry));
}

while creating table i want to declare for primary key and foreign key

which showing run time error (it crashes) during creation of table

what is right way to declare primary key

@rahulm: don't forget to accept at least some of the helpful answers you've already received to other questions. — Jonathan Leffler, Sep 08 '09 at 16:40
`Execute()` is not in Symbian SQLite API but in legacy Symbian DBMS API. Deleting sqlite tagging. — laalto, Sep 09 '09 at 07:05

score 1 · Answer 1 · answered Sep 08 '09 at 16:30

1

I don't know which DB are you using, but maybe this will help you

http://snippets.dzone.com/posts/show/1680

Try to use COUNTER data type instead of INTEGER and AUTOINCREMENT.

Another guess: isn't that AUTO_INCREMENT with underscore?

answered Sep 08 '09 at 16:30

Lukasz Lysik

10,462
3
51
72

score 1 · Answer 2 · answered Sep 08 '09 at 16:42

1

AUTO_INCREMENT is indeed with underscore, this is the error in that SQL

answered Sep 08 '09 at 16:42

transient_loop

5,984
15
58
117

score 0 · Answer 3 · answered Sep 09 '09 at 07:37

Seems like you're using the old legacy Symbian DBMS and not SQLite.

The old DBMS only supports a small subset of SQL. If my memory serves me well, that includes only some basic SELECT queries.

To create tables using the old DBMS, use the C++ API, e.g.

CDbColSet* columns = CDbColSet::NewLC();

TDbCol id(_L("CountryID"), EDbColInt32);
id.iAttributes = TDbCol::EAutoIncrement | TDbCol::ENotNull;
columns->AddL(id);               

columns->AddL(TDbCol(_L("CountryName"), EDbColText, 45));
columns->AddL(TDbCol(_L("CountryCode"), EDbColText, 10));

User::LeaveIfError(aDatabase.CreateTable(_L("Country"), *columns));

CleanupStack::PopAndDestroy(columns);

Or just use the more recent SQLite-backed RSqlDatabase API.

primary key declaration error while creating table

3 Answers3