If you can, define one of the data entries in your table (Schema defination) as "unique" when you create the table. The engine will then set an error condition (call the callback function) and this should prevent you from entering duplicate data and hence duplicate rows.
Michael -----Original Message----- From: RaghavendraK 70574 [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 8:00 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Duplicate Row check Q was incomplete. When i do a insert is there a way to know row already exists!! regrads ragha ************************************************************************ ****************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ************************************************************************ ***************** ----- Original Message ----- From: RaghavendraK 70574 <[EMAIL PROTECTED]> Date: Thursday, July 19, 2007 5:17 pm Subject: [sqlite] Duplicate Row check > Hi, > > How can check if a row exists in the db or not without querying for > it? > regards > ragha > > > ************************************************************************ ****************** > This email and its attachments contain confidential information > from HUAWEI, which is intended only for the person or entity whose > address is listed above. Any use of the information contained > herein in any way (including, but not limited to, total or partial > disclosure, reproduction, or dissemination) by persons other than > the intended recipient(s) is prohibited. If you receive this e-mail > in error, please notify the sender by phone or email immediately > and delete it! > > ************************************************************************ ***************** > -------------------------------------------------------------------- > --------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------- > --------- > > ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
