To get rid of the error, the command needs to return a value. It gives an error that The data content could not be loaded, but it still performs the update and changes the data. Registering the database (is done locally) and makes it easier for Writer and Calc to use. 3 A window will pop up titled 'Database Wizard' 4 Accept the default settings and click 'Next'. Update mytable set mycolumn = 'This is some text.' where ID = 59 Once it has been downloaded and installed, in Windows XP, go to Start -> All Programs -> Star Office 8 -> Star Office Base and then press the Enter key. Click the toolbar button to Run SQL Command directly.In the Queries section, Create Query in SQL View.I couldn't get this to work with the default built-in HSQLDB 1.8 engine, but it worked with MYSQL. Under some circumstances it is possible to create an update query.

Note that the data can also be modified with a form or by editing the table directly. StrSQL = 'UPDATE ''Table1'' SET ''Value'' = 'CCC' WHERE ID = 0' REM Run an SQL command on a table in LibreOffice BaseĬontext = CreateUnoService('.DatabaseContext')ĭatabaseURLOrRegisteredName = 'file:///C:/Users/JimStandard/Desktop/New Database.odb'ĭb = Context.getByName(databaseURLOrRegisteredName )Ĭonn = Db.getConnection('','') 'username & password pair - HSQL default blank Here is an example using Basic: Sub UpdateSQL The other way is to run the command with a macro. Enter something similar to the following, then press Execute: UPDATE 'Table1' SET 'Value' = 'BBB' WHERE ID = 0 Instead, the easiest way to do an update command is to go to Tools -> SQL. Base does not typically use update queries (but see below).

How to use openoffice database