--- dpark <[EMAIL PROTECTED]> wrote:
> It isn't clear to me why "create temp table as select ... where key
> <?" works as a prepared statement, but the analogous line for views
> doesn't.
I thought parameters in the CREATE TABLE variant - or any other DDL
statement - would be disallowed as well. Apparently not. Go figure.
I can only speculate that the running of CREATE TABLE is immediate
while the execution of the SELECT in the CREATE VIEW is deferred
so that the parameters cannot be used immediately, which may be the
issue.
Wouldn't the prepared CREATE VIEW be of limited utility since
the view name cannot be variable as well? Wouldn't you have to
DROP the view between its uses?
> Is there a generic JDBC spec somewhere that describes this in more
> depth? The normal Sun Java API docs that describe java.sql don't
> really explain what kinds of sql can and can't be run as
> preparedstatements, and what kinds of things are valid parameters.
I don't think JDBC drivers vet the sql, as many databases have their
own commands and quirks.
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
