My application naively tried preparing the statement: “CREATE VIRTUAL TABLE xxx USING zipfile(?1);” and binding the name of the zip file, supplied by user, to parameter 1 for execution. This doesn’t work, and the documention reveals that this is by design. I therefore have to expand the argument(s) myself to get the statement to prepare. The page says there are no restrictions on the argument other than balanced parentheses, leaving me unclear how the parser deals with the statement following left parenthesis after the module name. Do I make the argument a literal and double embedded occurrences of single quotes?
Even though my example used the zipfile module, I want to handle the general case. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users