Hi I would like to do the following
I have an item to insert in the table which will be inserted only if this item is not yet in that table otherwise I would like to return the item's key. like that IF 1==SELECT COUNT(*) from table WHERE item==new THEN SELECT itemID from tabel WHERE item==new ELSE INSERT INTO table (item) VALUES (new) It does not work in this way ... could somebody tell me please what is the correct sintax or whether this is possible at all. Thank You _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users