Hi RSmith,

  Thanks. Still, I could not delete with single query.


create table if not exists emp(key integer not null, name text not null ,
personaldata text not null, unique(key, name));
insert into emp (key, name, personaldata) values(1, 'a', 'z');
insert into emp (key, name, personaldata) values(1, 'b', 'zz');
insert into emp (key, name, personaldata) values(2, 'c', 'y');
insert into emp (key, name, personaldata) values(3, 'd', 'yy');
insert into emp (key, name, personaldata) values(1, 'e', 'yyy');

bool delete_emp(int key, string name = "")
{
        string query = ???;

        if(name.length() > 0)
        {
            //needs to delete specific row. by unique key.
        }
        else
        {
            //needs to delete rows belongs to key
        }
}


On Mon, Nov 18, 2013 at 2:13 PM, d b <va230...@gmail.com> wrote:

> Hi Luis,
>
> Those are parameters.
>
> This is the query after replacing with ?1 and ?2.
>
> delete from emp where key = '123' and (case when name = 'abc' is null THEN
> 1 else name = 'abc' end);
>
> It covered  "delete from emp where key = '123' and name = 'abc';" but not
> other query.
>
> I tried with "select  (case when name = 'abc' is null THEN 1 else name =
> 'abc' end) from emp;"  query. It's always going to else portion when 'abc'
> doesn't exist in table. Any suggestions?
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to