DELETE FROM <table> WHERE rowid = a AND refcount - 1 = 0
 
IF @@ROWCOUNT = 0
    UPDATE <table> SET refcount = refcount - 1 where rowid = a

 

Is conditional statements allowed in sqlite?

 

Regards,

Phani

Reply via email to