To get rid of the error, the command needs to return a value. , but it still performs the update and changes the data. Update mytable set mycolumn = 'This is some text.' where ID = 59 I couldn't get this to work with the default built-in HSQLDB 1.8 engine, but it worked with MYSQL. 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 The other way is to run the command with a macro. UPDATE "Table1" SET "Value" = 'BBB' WHERE ID = 0 Enter something similar to the following, then press 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).
0 kommentar(er)
