Hi Ray, > By "Currently you cannot edit view ..." do you refer to revising SQL > View through OO GUI? In OO Base 2.1.0, SQL View revision is easy by > using SQL statements through OO CUI (Tools - SQL).
Yes, but you cannot open the query designer - neither in graphical nor in SQL view - for editing an existing view. > SQL View with named bind parameters can be created and stored in OO > HSQLDB through OO Base CUI. However, neither OO Base GUI nor OO DSE > (e.g. from OO Calc) recognizes named bind parameters in SQL View. No > user dialog would occur. SQL developers are stuck, despite that named > bind parameter is supported in HSQLDB 1.8.0.7. Ah, now I understand the problem. In fact, parameters in views do not work at all in HSQL, neither named nor unnamed ones. Admittedly, I'm not sure at the moment whether this is on HSQL or on Base side, it might be a mix of both. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
