New to OpenOffice Base

Discuss the database features
Post Reply
tmanikanda
Posts: 21
Joined: Tue May 15, 2018 9:36 am

New to OpenOffice Base

Post by tmanikanda »

Hi All
I am new to openoffice base. I have just created few dialogs and macros in Calc. I want to learn base. Is there any tutorial for learning base and forms.
My simple requirement is to create form to enter and read data from base instead of calc. I am attaching a sample calc which is entering and updating contact details in a sheet. Instead of sheet i want to insert and update in a base table. Please help me.
Attachments
sample_contactlist.ods
(13.61 KiB) Downloaded 216 times
Apache OpenOffice 4.1.3 , Windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: New to Openoffice Base

Post by FJCC »

There is a good tutorial here.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
tmanikanda
Posts: 21
Joined: Tue May 15, 2018 9:36 am

Re: New to OpenOffice Base

Post by tmanikanda »

Thank you guys for the suggestion. It helped
I am using the Base data in Macro like below
Select SQL = " Select ""col1"" from ""table1"" "
SQLResult = oCreateStmt.ExecuteQuery(SelectSQL)
While SQLResult.next
Item = SQLResult.getString(1)
oVndrList.additem(Item , oVndrList.ItemCount)
Wend

Instead can i get the output of select query into an array
Apache OpenOffice 4.1.3 , Windows 10
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: New to OpenOffice Base

Post by UnklDonald418 »

LibreOffice has a "Base Handbook" that can also be helpful to beginners.
https://documentation.libreoffice.org/e ... mentation/
Look in the Base Books area.

Coding macros is something to be avoided if at all possible. Learn to use the power of the database engine coupled with forms, and only use macros for rare situations that can't be accomplished any other way.
You can use cut and paste to copy data from a spreadsheet into a Base table.
Then a use simple query, something like

Code: Select all

Select "Name", "Contact" from "tbl_Contacts" 
to display all the records in the table.
If you "Use Wizard to create Form" using the table as the data source, you can add a table control to the form where you can display and edit the data much like on the spreadsheet.

Be aware that in Base there are several words that can have multiple meanings, "Form" being one. On the main database window is an area called Forms. Each of the items in the list are actually form documents, a special type of Writer page. Each of those documents can contain one or more Forms, each with their own data source (a table or query).
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply