--- dpark <[EMAIL PROTECTED]> wrote:
> But the following line in java throws an SQLException:
>
> PreparedStatement prep = conn.prepareStatement(
> "create temp view "+newTable
> +" as select * from "+table
> +" where key >= ? and key < ?;");
>
> Specifically: "java.sql.SQLException: parameters are not allowed in
> views."
>
> Something doesn't seem quite right here... perhaps the parser thinks
> I'm passing parameters to the create temp view
Because you are passing parameters to CREATE VIEW.
It's correctly rejected for the same reason you cannot code
"select ? from ?".
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
