Macros/Base/ba002

    From The Document Foundation Wiki
    < Macros‎ | Base
    Other languages:

    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