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.
New to OpenOffice Base
-
- Posts: 21
- Joined: Tue May 15, 2018 9:36 am
New to OpenOffice Base
- Attachments
-
- sample_contactlist.ods
- (13.61 KiB) Downloaded 216 times
Apache OpenOffice 4.1.3 , Windows 10
Re: New to Openoffice Base
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 21
- Joined: Tue May 15, 2018 9:36 am
Re: New to OpenOffice Base
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
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
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: New to OpenOffice Base
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
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).
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"
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11