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