New to OpenOffice Base

Discuss the database features

New to OpenOffice Base

Postby tmanikanda » Mon Aug 06, 2018 3:28 pm

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 32 times
Apache OpenOffice 4.1.3 , Windows 10
tmanikanda
 
Posts: 21
Joined: Tue May 15, 2018 9:36 am

Re: New to Openoffice Base

Postby MrProgrammer » Mon Aug 06, 2018 4:29 pm

tmanikanda wrote:Is there any tutorial for learning base and forms.
Screen Shot 2018-08-06 at 09.26.20 .png
Perhaps [Tutorial] Forms in OpenOffice.org Base which you will find in that section of the forum.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Last edited by MrProgrammer on Mon Aug 06, 2018 4:34 pm, edited 1 time in total.
Mr. Programmer
AOO 4.1.5 Build 9789 on Mac OS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3520
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: New to Openoffice Base

Postby FJCC » Mon Aug 06, 2018 4:31 pm

There is a good tutorial here.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 6884
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: New to OpenOffice Base

Postby tmanikanda » Fri Aug 24, 2018 3:59 pm

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
tmanikanda
 
Posts: 21
Joined: Tue May 15, 2018 9:36 am

Re: New to OpenOffice Base

Postby UnklDonald418 » Fri Aug 24, 2018 7:08 pm

LibreOffice has a "Base Handbook" that can also be helpful to beginners.
https://documentation.libreoffice.org/en/english-documentation/
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   Expand viewCollapse view
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.6 & LibreOffice 6.1.1.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 978
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests