https://bugs.freedesktop.org/show_bug.cgi?id=83737
Priority: medium
Bug ID: 83737
Assignee: [email protected]
Summary: BASE MACRO: Cannot use macro to save new row:
insertRow function returns Function Sequence Error
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: Inherited From OOo
Component: BASIC
Product: LibreOffice
1. In Base, open form for editing
2. In a macro on the form, set oParent as the form and call method
oParent.insertRow on a control in the form.
3. Open form and send cursor to new row.
4. Activate macro (execute oParent.insertRow)
This should insert the new record into the database, but it does not. Instead,
it returns the following error:
BASIC runtime error.
An exception occurred
Type: com.sun.star.sdbc.SQLException
Message: Function sequence error..
The problem was documented in 2010 with OOo on the following message page:
https://forum.openoffice.org/en/forum/viewtopic.php?f=39&t=36903#p169447
Specific implication is that form cannot obtain autogenerated parent key for
additional functions, because key is autogenerated by database and record is
not saved.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
