Hi, Suppose that I have a table with three columns h1, h2, v. I want to delete all rows with h1=a, and insert rows like the following (data shown in TSV format), only if there is not an entry with h1=a and h2="" (empty), it exists but its v is not equal to a value X.
a,A,v1 a,B,v2 ... https://www.sqlite.org/lang_insert.html I am not sure if there is a way to check an entry to know whether new entries can be inserted. Could anybody show me an example if this can be done? -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
