> Le 17 juin 2016 à 13:35, Hick Gunter <h...@scigames.at> a écrit : > > Does > > .pragma table_info(<tablename>); > > not solve your problem? >
I indeed need PRAGMA table_info(), to get type names from column names. Let my rephrase my question: Find a generic way to retrieve column names and table name (and then column types with above pragma) in a arbitrary single SQL statement for all placeholder values. Examples: "INSERT INTO t1(col1, col2) VALUES(2, ?); » => (t1, col2) "UPDATE t2 SET col1=? WHERE col2=? " => (t2, col1) and (t2, col2) "SELECT * from t1 WHERE col2=?" => (t1, col2) With regular expressions, I was in fact able to implement my feature for INSERT and UPDATE in a acceptable way (without supporting the WHERE nor WITH clauses). But I was asking if there is a better solution, not requiring slow regex, using information SQLite3 already has internally about placeholder values. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users