Where to find funtions explanation like oForm.moveToInsertRow()

Good night to all.
I’m trying to understand Basic macros.
For example this funtion “oForm.moveToInsertRow()”
Where can I get information about this function (moveToInsertRow()), and what functions are available to what Libreoffice objects?
Is there any IDE with autocomplete?
Thank you!

https://api.libreoffice.org/IDL Reference. Use search box at the top right.

No definitive reference (except run-time inspection, using tools like Basic’s Watch, MRI, or Object Inspector). There are also tutorials like those collected on our Macros wiki page; but in general, all static guides may get obsoleted at any time, because LibreOffice API is not about “what objects have what properties / methods”, but “what interfaces and services are implemented by a given object”, with the list being subject to change, and the intended paradigm is to check the supported interfaces / services at run time.

Couldn’t ask for more!
Thank you very much!

LibreOffice Basic Help

where from ? :confused:
Property or method not found: ViewSettings - #2 by Villeroy

hopefully sooner : GSoC-2025: BASIC IDE code auto-completion in LibreOffice
… than later [GSOC 2013] Code completion in the Basic IDE – The Document Foundation Mailing List Archives :expressionless:

meanwhile :
Development Tools
Request: an easy object reference for people coming from office VBA

I’m trying to understand Basic macros.

Here is what LO has about Macros in general

that includes links to Andrew Pitonyak’s website which has lots of explanations for Basic Macros, Unfortunately, he has very little on the Base Module.

The book “OpenOffice,org Base and Basic” by Roberto Benetez is out of print, hard to find and I didn’t find anything there that would answer your question about “oForm.moveToInsertRow()”

Chapter 9 of the LO Base Guide
begins with sage advice “In principle a database in Base can be managed without macros.”
But it does present some useful code.

what functions are available to what Libreoffice objects?

For that you need the MRI extension

The official MRI documentation

This tutorial might also be helpful

A quick Google search revealed

The method oForm.moveToInsertRow() is a function used in database programming contexts, specifically within applications like LibreOffice Base or OpenOffice.org Base, which utilize the UNO (Universal Network Objects) API.

Its purpose is to prepare a form for the creation of a new record. When oForm.moveToInsertRow() is called, the form’s cursor or focus is moved to a new, empty row, signifying that the subsequent operations will involve inserting data into this new record.

After calling this method, the user or macro can then proceed to populate the fields of this new record, typically by using updateXxx methods (e.g., updateString, updateInt) to assign values to the various controls or columns within the form. Finally, the new record is committed to the underlying data source (e.g., a database table) using a method like oForm.insertRow().

In essence, oForm.moveToInsertRow() initiates the process of adding a new data entry to a database table through a form.