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.4 RC2
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]
> >
> >
>
