Frank, 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. SELECT * FROM V1 on the other hand returns two records 0, Harry 1, Harriet as expected. On 9/18/06, Frank Schönheit - Sun Microsystems Germany < [EMAIL PROTECTED]> wrote:
Hi Andrew, > A view can be created with a criteria, but these must be literal. ( as > mentioned above - fixed at the time of creation ) > > I ran a test - just now - using both the 1.0.8.5 jar with OOo 2.0.4 and > HSQLDB 1.0.8.5 in server mode with the supplied database manager as a swing > application. > > If I attempt to execute a Create view command with a statement such as this > it fails. > > The test consisted of running the following commands as a script in both > CREATE TABLE TEST1 ( ID IDENTITY, VAL VARCHAR( 50 ) ); > INSERT INTO TEST1 VALUES ( NULL, 'Tom' ); > INSERT INTO TEST1 VALUES ( NULL, 'Dick' ); > INSERT INTO TEST1 VALUES ( NULL, 'Harry' ); > INSERT INTO TEST1 VALUES ( NULL, 'Thelma' ); > INSERT INTO TEST1 VALUES ( NULL, 'Donna' ); > INSERT INTO TEST1 VALUES ( NULL, 'Harriet' ); > CREATE VIEW V1 AS ( SELECT * FROM TEST1 WHERE VAL LIKE 'H%' ); > CREATE VIEW V2 AS ( SELECT * FROM TEST1 WHERE VAL LIKE :PART_NAME ); > > In both environments the last statement throws an error, ':: unrecognized > token'. Do you mind trying this with "?" instead of ":PART_NAME"? I actually don't know whether HSQLDB currently really supports parameters in views, but the above might not work because it previously did not support *named* parameters *at all* (we added support for it during the QiQ implementation). > The concatenation token of double pipes not being recognized by the base > query designer- I believe, and Frank will scold me if I am > wrong...*chuckle*..was just a dumb mistake. Let's call it oversight ;) Ciao 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]
