Re: [sqlite] Re: Check for duplicate values in database

2006-05-29 Thread Derrell . Lipman
"Anish Enos Mathew" <[EMAIL PROTECTED]> writes: > Igor, I know that it will show error when we try to insert a value which > is already there in the database when that field is a primary key. But > I want to check it out and I don't want that number to be inserted into > the database. I was

RE: [sqlite] Re: Check for duplicate values in database

2006-05-29 Thread Anish Enos Mathew
to terminate the program and have other numbers in a loop to be inserted into the database. Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, May 29, 2006 7:52 PM To: SQLite Subject: [sqlite] Re: Check for duplicate values in database Anish Enos Mathew <[EMAIL PROTEC

[sqlite] Re: Check for duplicate values in database

2006-05-29 Thread 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