Macros/Base/ba002
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Description
Execute update in current database
Basic code
Sub main()
doc = ThisComponent
conn = doc.DataSource.getConnection("", "")
sql = "UPDATE ""contactos"" SET ""numbers""=TRIM(""numbers"")"
cursor = conn.prepareStatement(sql)
result = cursor.executeUpdate()
doc.store()
MsgBox result
End Sub