[sqlite] Re: Duplicate Row check

[Igor Tandetnik]

RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:

Q was incomplete.
When i do a insert is there a way to know row already exists!!


If you have uniquness constaints in place that prevent insertion of the 
duplicate row, your statement will fail with SQLITE_CONSTRAINT error.


Igor tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: Duplicate Row check

[Igor Tandetnik]

RaghavendraK 70574
<[EMAIL PROTECTED]> wrote: 

How can check if a row exists in the db or not without querying for
it? 


Or in other words: how can I read a book without opening it first?

Igor Tandetnik

-
To unsubscribe, send email to [EMAIL PROTECTED]
-