Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Steven Friedrich wrote:
I'm looking for a place where I can ask questions about programming Base
applications, using LibreBasic and the API.  Is this the right place?

To save a little time, let me explain my question.

I have a Base Form that uses a ListBox based on a SQL query.  When a record
is updated, I want the ListBox to requery.

In Microsoft Access, I just said Requery and I didn't even need to specify
the control.

How do I get a Form to requery in LibreOffice?

I am not sure I understand your question, so I may be offbase here (no pun intended).

What you call requerying sounds like it may be the same as Refreshing in Base Forms. Have you tried the "Refresh" icon(s)? At the bottom of my forms, just about in the middle of the top toolbar, there are two refresh icons. The left one looks like a rotating arrow and has a "Refresh" help popup. The icon to the right of that icon looks like a "radio button" and a rectangle with two rotating arrows, one out of the radio button and one into the button. This icon has a help popup of "Refresh Control".

Whenever I change a table that a listbox is referring to, that change does not immediately get reflected in my form's listbox entries. I must click on the listbox (not the pulldown list, just highlight the listbox control itself), then click on the "Refresh Control" icon. Then the listbox should update. Clicking on the "Refresh" icon will refresh (reload?) the entire database and restart you back to record #1 again, as if you reopened the form. "Refresh Control" will just refresh the control that is selected.

Hope this helps.
Girvin Herr

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.