[sqlite] Re: Check for duplicate values in database

[Igor Tandetnik]

Anish Enos Mathew <[EMAIL PROTECTED]>
wrote:
         I created a table as follows.
        create table data_table(seq_number integer primary key,data
text,curr_date text)",NULL, NULL, NULL);

        I want to insert 100 records into the database randomly. Here
"seq_number" is the primary key. Is there any method by which I can
check whether a randomly selected number which I am going to insert in
the database already exists in the database or not?

Being a primary key, the database engine will enforce its uniqueness. 
Just try to insert and check for errors, the operation will fail if this 
key already exists.

Igor Tandetnik