Using the example above I see one not documented issue. When I use parameters ?NNN and :AAAA or @AAAA or $AAAA , in same query as above some of then will be omitted. I don't know if this is the expected behavior or not.
CREATE TABLE a (a, b); CREATE TABLE b (a, b); INSERT INTO a VALUES (0, 1); INSERT INTO a VALUES (1, 0); INSERT INTO a VALUES (1, 1); INSERT INTO b VALUES (0, 1); INSERT INTO b VALUES (1, 0); INSERT INTO b VALUES (1, 1); SELECT * FROM a JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) WHERE a.a = ?1; In this query as 2 parameters but will be see like only one! -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
