https://bugs.documentfoundation.org/show_bug.cgi?id=164465

            Bug ID: 164465
           Summary: An error occurred in a Base form when executing a
                    macro.
           Product: LibreOffice
           Version: 25.2.0.0 alpha0+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 198265
  --> https://bugs.documentfoundation.org/attachment.cgi?id=198265&action=edit
Database

An error occurred in a Base form when executing a macro.
This macro is not new. I have been using it since OpenOffice, quite a few
years. It has never shown an error before.
LibreOffice Base Firebird.
When running in LibreOffice 25.2 RC1 the following comes up:

Error de ejecución de BASIC.
Se ha producido una excepción
Type: com.sun.star.sdbc.SQLException
Message: firebird_sdbc error:
*value exceeds the range for valid dates
caused by
'isc_dsql_execute'

Macro:

Sub ActualizarFechaAnterior( Event )

   obj = Event.Source.Model
   fecha_seleccionada = obj.Text
   fecha_anterior = DateAdd("d", -1, fecha_seleccionada)
   frm = obj.Parent
   obj_fecha_seleccionada = frm.getByName("fecha_inicial")
  
obj_fecha_seleccionada.BoundField.UpdateString(Format(fecha_seleccionada,"YYYY-MM-DD"))
   obj_fecha_anterior = frm.getByName("fecha_anterior")
  
obj_fecha_anterior.BoundField.UpdateString(Format(fecha_anterior,"YYYY-MM-DD"))
   frm.UpdateRow

End Sub

Version: 25.2.0.1 (X86_64) / LibreOffice Community
Build ID: ddb2a7ea3a8857aae619555f1a8743e430e146c9
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+wayland)
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Sistema operativo: Fedora Linux 41
Versión de KDE Plasma: 6.2.4
Versión de KDE Frameworks: 6.9.0
Versión de Qt: 6.8.1
Versión del kernel: 6.12.6-200.fc41.x86_64 (64 bits)

Form: "Informes"
Control: "Fecha de Inicio"
Action: "when changing date"

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to