Hi Andrew, >>>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"
> Alright, assuming I put back the correct jar - dated 7/10/2006 Hmm, HSQL is less advanced here than I originally thought, then :( Which makes adding parameter support to views would be impossible on OOo side alone ... Thanks & Ciao (and, well, good night :) Frank -- - 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]
