Macros/Base/ba002

From The Document Foundation Wiki
< Macros‎ | Base
Jump to navigation Jump to search
Other languages:
English • ‎italiano

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