I wonder if someone can recommend a good reference to handling forms from basic macro. I am familiar with Andrew Pitonyak’s OpenOffice.org Base Macro Programming, but I remain confused.
I have a series of Forms relating to a table with very long records and a basic macro passes control from one Form to the next. The macro must obviously update the record as it goes. If I understand correctly, first each field on the Form must be committed, and then the row updated (or inserted when the first Form creates the record in the table). However I get a variety of errors such as “Input required in field ‘X’. Please provide a value” (although the field should not require an entry), ‘Sequence error’ and “Row set veto exception.”
Exactly how should the values from the form be written to the table record?
Ubuntu 18.04 LO 220.127.116.11