Alright, assuming I put back the correct jar - dated 7/10/2006
No difference - same error. Drew On 9/18/06, Andrew Jensen <[EMAIL PROTECTED]> wrote:
Now to be sure I should do something first. I am using a HSQLDB jar file from a download off the HSQLDB site, not the one with the distribution. Let me go back and re-configure this to use the one that came with 2.0.4RC2 and try again. On 9/18/06, Andrew Jensen <[EMAIL PROTECTED]> wrote: > > 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] > > > > > > > > >
