Hi Vivien, >> BareFeet wrote: >> >> Is there any way to parse a create statement (eg create table, create view, >> create trigger) into its components? >> >> Since SQLite does this internally using the Lemon parser, surely there's a >> simple way to get the parser results?
Vivien wrote: > You can use SQLite's own SQL parser > (http://www.hwaci.com/sw/lemon/lemon.html) with SQLite's own grammar > (to ba found in SQLite's sources) and adapt it to you needs. That's the theory, but how can I do that easily? It seems that I either have to reverse engineer the virtual machine code it produces or else write my own parsers in Lemon. I would hope there's a way to intercept the parsing built into SQLite to extract the parse tree, but none of my attempts to investigate this have been fruitful. Thanks, Tom BareFeet -- Comparison of SQLite GUI tools: http://www.tandb.com.au/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
