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]
