Create a primary key with autoincrement in Symbian DBMS
CREATE TABLE person (id COUNTER, name VARCHAR) CREATE UNIQUE INDEX id_index ON person(id)
COUNTER is UNSIGNED INTEGER with Autoincrement.
You still need a UNIQUE INDEX as well.
DZone Snippets > autoincrement
11384 users tagging and storing useful source code snippets
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
CREATE TABLE person (id COUNTER, name VARCHAR) CREATE UNIQUE INDEX id_index ON person(id)