hi ,
i got a confusion in deleting a entry,
sqlite> create table hai (key text primary key,value text) ;
sqlite> create table hai (key text primary key,value text) ;
SQL error: table hai already exists
sqlite> insert into hai (key,value) values ('hai1','value1');
sqlite> insert into hai (key,value) values ('hai1','value1');
SQL error: column key is not unique
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> insert into hai (key,value) values ('hai1','value1');
sqlite> insert into hai (key,value) values ('hai1','value1');
SQL error: column key is not unique
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = hai1;
SQL error: no such column: hai1
sqlite> delete from hai where key = hai1;
SQL error: no such column: hai1
sqlite> delete from hai where key = hai1;
SQL error: no such column: hai1
sqlite> delete from hai where key = 'hai1';
sqlite> delete from hai where key = 'hai1';
sqlite>
i think ,it should delete the record,it doesn't delete,with api's or thro
shell.
please do tell me what am i doing wrong
Thanks & Regards
Narendran B
--
View this message in context:
http://www.nabble.com/problem-in-deleting-tf2428522.html#a6771178
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
