Translations:Macros/Base/py002/6/en

    From The Document Foundation Wiki

    sql = 'UPDATE "contactos" SET "numbers"=TRIM("numbers")'

       cursor = conn.prepareStatement(sql)
       result = cursor.executeUpdate()
       doc.store()
       return
    

    </syntaxhighlight>