CREATE OR REPLACE works like a charm... If there are people who are ready to test this first version, then I'm interested because it saves me a lot of time (because unfortunately I'm not paid ;-)
Here is the download link: jdbcDriverOOo <https://github.com/prrvchr/jdbcDriverOOo/blob/master/jdbcDriverOOo.oxt> and the documentation <https://prrvchr.github.io/jdbcDriverOOo/>. You must have Java version 11 minimum, and I recommend LibreOffice because the port to OpenOffice has not yet been done. To have access to the extended mode of the driver you must validate the extended mode in: *Tools -> Options -> Base drivers -> JDBC Driver* and chose *com.sun.star.sdbcx.Driver* in *Driver UNO Service*. A restart of LibreOffice is needed. This driver is not finished, it remains to manage the Indexes, the users and the rights on the tables... Thank you for your help. Le mardi 5 juillet 2022 à 11:58:45 UTC+2, prrvchr a écrit : > Hi Evgenij, > > Thank you for answering me. I will use: > > CREATE OR REPLACE VIEW viewName AS .. > > Le mardi 5 juillet 2022 à 11:50:20 UTC+2, prrvchr a écrit : > >> Hi Andreas, >> >> The UNO API also provides an interface com.sun.star.sdbcx.XRename >> <https://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbcx/XRename.html> >> >> to change the name of a view, but apparently this interface is not >> implemented in Base because it is never called. >> >> But I don't want to rename the view but change its command, and I can't >> find a command in H2 to do so. >> Please advise me the best alternative. >> >> >> Le mardi 5 juillet 2022 à 11:38:52 UTC+2, and...@manticore-projects.com >> a écrit : >> >>> Greetings! >>> >>> On Tue, 2022-07-05 at 02:36 -0700, prrvchr wrote: >>> >>> What is the best alternative with H2? >>> >>> >>> H2 has a really excellent documentation: >>> https://www.h2database.com/html/commands.html >>> >>> Your are looking for: >>> https://www.h2database.com/html/commands.html#alter_view_rename >>> >>> Best regards >>> Andreas >>> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/8023a814-b3fd-495b-ba12-8d639bac7d18n%40googlegroups.com.