Igor Tandetnik <[EMAIL PROTECTED]> wrote: Michele Simionato wrote: > I forgot to say that I would like a solution working from sqlite3, the > console, not from the > programming interface. PRAGMA table_info(tableName);
Igor Tandetnik What happens when your SQL query includes any of these: select 'abc' as my_literal; select 24*7 as my_literal_2 from tab_1; select * from tab_1 , tab_2; select .. Well, I am sure you get the idea :-) Given the current state of the api's, this seems to require full sql parsing on part of the developer, which not realistic, especially from sqlite3 or tcl interfaces. --------------------------------- Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice.