I am using LibreOffice BASE with a form and a basic macro to generate pdf files from a simple database. Something akin to mail merge. For the most part it works but sometimes the data in the generated file doesn’t match which record should have been retrieved in the form with the ResultSet.getString macro command. Is there a macro command that syncs or overtly loads the data before I proceed to print. This is LibreOffice 4.0 running on RHEL6.
This isn’t an answer to the syncing question per se but the macro worked better if I put a small delay between ResultSet.Next and ResultSet.getString. Apparently that gave it enough time to load the data record correctly before retrieving the field I was processing.