OK - here is the code sub main dim oConn dim oPrepStmt dim oRecSet
oConn = fnGetConnection( "Inventory" ) oPrepStmt = oConn.PrepareStatement( "SELECT * FROM V2" ) oPrepStmt.setString( 1, "H%" ) oRecSet = oPrepStmt.Execute oConn.Close oConn.Dispose end sub The setString thows the error "Invalid argument JDBC call: parameter index out of range: 1" On 9/18/06, Andrew Jensen <[EMAIL PROTECTED]> wrote:
Just to be sure - You mean leave the V2 created as is. Then using a prepared statement with SELECT * FROM V2 and see if it lets me set the parameter? I will try it and see. BRB On 9/18/06, Frank Schönheit - Sun Microsystems Germany < [EMAIL PROTECTED]> wrote: > Hi Andrew, > > > Just tried this in the HSQLDB Database Manager and the SQL window in > Base. > > > > CREATE VIEW V2 AS ( SELECT * FROM TEST1 WHERE VAL LIKE ? ) > > > > The command is accepted and a view is created named V2 - however if > you then > > do > > > > SELECT * FROM V2 > > > > in the Manager and as a query in Base you are returned an empty result > set > > in both. > > Now the next interesting question - if such a statement is prepared via > API, and parameter values are filled in before actually executing the > prepared statement - does this return results? > > Ciao > Frank > (sorry for not trying myself, but you just seem to be running :) > > > -- > - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - > - Sun Microsystems http://www.sun.com/staroffice - > - OpenOffice.org Database http://dba.openoffice.org - > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
