--- 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]
-~----------~----~----~----~------~----~------~--~---

Reply via email to