Thank you for a useful series of tutorials; I have worked through several of them. However, Base (Version: 6.4.7.2) will not open my new database due to absence of Java. The LibreOffice help files describe the problem but there is nothing of any use to help resolve it. Any advice?
Try Downloading java from here: java.com/en/download/manual.jsp You may need to make sure LibreOffice can see it by choosing the version you just downloaded in: Tools - Options - LibreOffice - Advanced - select Java runtime environment
Did you realize that this video series is now 11 ELEVEN years old? It is nearly impossible to find current videos that actually work with current software whenever I look for it. But, in spite of ten years worth of advancements, and I watched LibreOffice go through some great changes, especially with their Writer, YOUR BASE VIDEOS ARE STILL UP TO DATE!!!!!!!! I want to let you know that I love that your videos are short, sweet and to the point. I don't think I have even given MS Access the time of day for over 25-30 years. Yet, yesterday, I was able to pick up Base, and using your videos, completely from scratch, design and build an application I wanted in just a few hours. Your videos are short, sweet and to the point so I was able to go directly to the episode I needed to get every answer I needed when I needed it. I only had to Google one question and the answer was at the top of the first page in the summary. I don't know if I'm praising you, which you deserve for your wonderful video series, or LibreOffice for being so consistent and keeping their Base software so backward compatible. Have a great day and keep up the good work. I appreciate you Shabbat Shalom
If you want to build a Libre Office Base project, this is the spot. There are 94 videos that cover almost every thing you need to know. I taught myself to use Microsoft Access and spent many months developing a project 20 years ago. As I watch these videos they bring back the concepts and provide the steps I need to create a new project in Base an excellent program at a Frugal price. Thank you FRUGAL Computer Guy. Wish I had this info 20 years ago but You Tube didn't exist then (did it).
Thank You. These are not just the best LibreOffice Base tutorials, but the best tutorials, period. I have never seen anything complex explained so clearly yet simply. This guy is amazing.
I really needed this series. I tried to learn databases a long time ago and got messed up with the multi table part and foreign keys. Just watched the short video on the primary and foreign keys and I knew I needed to watch the whole playlist on LubreOffice Base. I finally feel I will end up understanding it finally. Thank you! I see you have a lot of other great topics and I will be watching them as well. I feel a sense of relief already.
Okay I am back for the second time. The first time was to watch the necessary ones to accomplish my immediate goal. Ha. Now I am back for the overall training. Thank You! Your material is absolutely superior.
Thanks very much for making all your tutorial videos. They're excellent! It must have taken many hours planning, preparing, and recording them. The quality of information and manner of presentation are very professional. I have just given a donation via your web site. Thank you very much for your commitment.
+richardnz100 Hello Richard, Yes they did take a lot of time to plan, prepare, and record. I really appreciate my viewers and try to give them the best tutorials I can. Yes, I received the donation - Thank you. Receiving donations really means a lot to me because it shows me you got enough value out of my videos to make a donation. And I do appreciate the people who click the thumbs up and/or take the time to send a thank you comment too - Thanks for watching!
Wow! Such a useful series. It has just passed its fifth birthday but almost everything is still relevant, because of the way LO adds features but does not remove them. As a Linux user by choice, but formerly trained on Ms Access I found the rest of LO intuitive but Base obscure in so many places. I find it especially useful that you show exactly where to find each control on the page, as that is what I (personally) am having most trouble with. Warmly River~~
It's a fantastic collection of database videos you've made here, I've been following them with great pleasure, they've been very helpful, Thanks for the great work
I really don't have a use for a program like this, but I was just curious about what it did, and you did a great job explaining how to use it and what it is for. This was a great tutorial.
Wow! Thank you for the great tutorials. Very clear and step by step. In the process of importing my records from Access and making forms and reports into Libre. I've been a Word user since it was on a 360K floppy. It's horrible what Office and Windows have become. When my DB in Libre is set up, I'm done with MSOffice.
Thanks for sharing your knowledge with us! LibreOffice at least for my pc is much more easier to use and doesn't consume much space from my HD! I will definitively watch the rest of the playlist!
Very nice video tutorial, very well explained. Just a little advice: make playlist based on every application. Right now I would like to watch just the LibreOffice Base tutorials.
Good eye to catch that! In the video, you will see that I try to save my table after typing in the last name of the second record, but before I typed in the first name (both required fields). LibreOffice incremented the auto value and tried to save the record (It couldn’t enter it at that time) after I typed in all required fields, I clicked save, it incremented (again) and added the autovalue to the record.
Thank you! That’s a great compliment. I’ve got a basic windows 7 home premium computer and the screen capture software I use is Microsoft Expression Screen Capture (It was free with windows 7, but I did have to download it separately).
Thank you so much!! I did not have ms office 365 but in school, we were supposed to do it...I found this as a good alternative but because of the java issue, I could not use it..thanks again!!
Actually, I don't have a complete plan (yet), so I can't say for sure how long this is going to be or what will be covered, but that's how all my series start. I have some idea's to work with and right now, it seems there may be a lot of videos, but we will have to wait and see...
Fantastic!! I struggled a lot to make a data base (I'm not a computer guy, at all) untill I found your channel. I love your pedagogy. In the past I tried some books but all of them or taught data base design from a rather teoretical view without specific software connection or explained how to use a software assuming one is already profiency in data base design. With your material I've been introducing me in both subjects simultaneously. I'm currently using LibreOffice 6; any chance you update the material to cover the new LO capabilities. Please. PD: sorry for my english, I'm an spanish speaker so...
This video clearly goes around the most obvious problem with Libre and OpenOffice base. Not being able to search fields on the form is so basic that Base is by no means a serious competitor to Microsoft Access - a developer simply can not make a user friendly GUI.
I've used your Calc and Writer tutorials to learn enough for me to get work. I am looking forward to using this series too. You provide a great service with your tutorials, they are the simplest and best series I've come across - free or paid. What hardware-software do you use to produce your videos?
Thank You so Much, I've been reading for mouths now about how to use databases and have learned a lot. I'm A hands on, trial and error learner but man you have showed me a lots in a shorter time than reading and everyone still needs to read a lot of the apps. help intros but these tutorials will save you a lot of time,it has me Thanks again TheFrugalComputerGuy.com
I spent several years using MS Access. Now I'm 74 and want to use Base as much for sentimental reasons as anything. I'm 74 and using LO 4.3 on a win7 box. Two questions: (1) you say Base is only the front end of a db, but I see relationships, queries, wizards, report builders etc. (2) due to prior warnings, I've 'turned off' java. IN YOUR OPINION, should I 'reinstall' java? if so, what ver? Gramps... Sharpsburg KY USA
Ma perchè in Italia non esistono persone come te che fanno Video cosi interessanti??? WHY?? Come posso fare a tradurre i tuoi video??? Grazie di esistere
Huh, looks like a great video series. >Does pretty good for first 5 minutes OK sweet, it's in an accent I can easily understand... >employess /me watches on with hopeful optimism...
These videos you have created are incredible. But for me,my eyes just gloss over when trying to learn. Sir can you point me to exactly which program within Libre Office i can use to create a phone number list and then alphabetize the list? Thank you very much.
why don't you use LibreOffice Calc? Set up columns with a name/title in the top row and fill in the information you have. Suggested column name/titles; phone, last name, first name, street, city, zip, birthday, etc You can easily add information any time and sort by any column (last name) to put all in alpha order any time
Hello i am new subscriber. How can i make a list of different doctors and results from blood tests all itemized. Are you still making BASE tutorials from new versions or are they all the same? I am a senior and need help. Thank you Michael
Hi I was wondering if you could help me set up my data. I have two instructional works I want to compare. They have written similar steps in the instruction but there are differences. In addition, there are multiple components within each step. I was looking at your multiple tables video but am not sure if I could eventually make the correct relationships. For Table 1: I was thinking of creating 2 rows of Instructional Work #1 and then #2 and then giving each instruction work an ID; in the columns I was going to write out all the steps. But instead of writing the different components of each step as separate columns (like your work phone number, cell, home, etc) I was thinking I should create another table for each instructional step (Table 2). Then in Table 2 I would assign each row the instructional work ID so I could create a relationship between each table. My question is: How do I create a unique ID? I don't have 2 variables like your phone number situation that together creates another unique situation that could become a new unique ID. I only have 2 instructional works like 2 employees. Help! -Kay
Hi, thanks a lot for the tutorial, your the way you explain things is very clear and makes it easy to learn it, just one thing, I can't find "odb00-employee-calc-table.ods" in your site (a few comments before you instructed someone to search for it "under Group 2 video 3"), can you post a url or may be point me in the right direction? Thanks again for all your hard and very effective work
Hello Mr. Frugal. I need to create a customer searchable database for issues they may face and possible solutions (which will come in the form of recommended books and/or activities). Does that make sense? Would LibreOffice Base be a good place to create that database? I get the sense that it can receive information (currently in Excel) but my main reason in switching to a database would be because the Excel list we have is clunky for our customers. Thank you for your advise.
Greetings! Yes, Libre Office Base this time, I’ve had a lot of requests for this topic. As with the other modules - there is a lot to it! This could be a long series...
When I clicked save, and did not have all the required fields filled in, it tried to use the number 1 and could not. It moves on to number 2 - That is what happened to the number 1 in the video. Anytime you try and save a record without all the required fields filled in, you will loose an auto-populate number.
your video is good but when we enter data type as number or integer then while filling the table details that should not accpet charachters.. its accepting no & char both.. how?? can you reply?
Just a note that you probably know but isn't varchar (considering giant databases) less efficient speed wise than a fixed char (assuming that you can determine a decent fixed length) due to random access? Probably no noticeable difference for even medium sized databases but it just bugged me a bit to hear you say "efficient" rather than highly convient and with a non-noticeable speed difference (though this is a tutorial on Libre's Base not on how computers work internally so...forgiven of course :))
Sorry - one last thing. My purpose is: I basically want to be able to make queries so I can compare the steps of both instructional works at the same time in the same form. Even if the steps of each instruction work exists in separate tables. I was thinking I could display the steps as those tables you showed underneath the form. Is this possible?
Hello Michael, I want to create a new table with a primary key as a series which is a combination of text + | + Integer (5001) for example. How can I achieve this? Please help me here.
I notice you retyped the whole calc spreadsheet by hand... and made some errors. Isn't there a way to import data from another LibreOffice app into the database? That would be slick, esp. for my 400 plus entry database! I see The Frugal Guy doesn't answer questions. Anyone else know the answer? Anyone? Bueller?
Even if the steps of each instruction work exists in separate tables. I meant to say: Even if the components of each step of both instruction works exist in separate tables. (So Table 1 doesn't get crowded and messy looking like your phone number situation)
FYI, I'm using LibreOffice 6.3.3.2. To get sbase to work, I had to install the following. (I asked for libreoffice-base, but had to add sdbc. I threw in the other database connectors (mysql, hsqldb, and postgresql), and the rest got pulled in as dependencies.) libtommath1:amd64 libfbclient2:amd64 libib-util:amd64 firebird3.0-server-core:amd64 firebird3.0-utils:amd64 libreoffice-base-drivers:amd64 libreoffice-base:amd64 libreoffice-evolution:amd64 libreoffice-java-common:all libreoffice-sdbc-firebird:amd64 libreoffice-dmaths:all libreoffice-templates:all libhsqldb1.8.0-java:all libreoffice-sdbc-mysql:amd64 libreoffice-mysql-connector:amd64 libreoffice-sdbc-hsqldb:amd64 libreoffice-sdbc-postgresql:amd64 (Firebird was pulled in as one of the dependencies.)
I am a mac user and what to create a database with photos for real estate and a comprehensive directory all centered around photos. Pls direct me to training material which cover the topics. Thanks
Hey, I really enjoy your work, you make it look so nice and easy. I've come across 1 problem: in my data base i wanted to change the field type which appeared on the field name 'Criteria" from Number to Integer and it said "the column could not be changed, should the column be deleted and the new format appended?" I clicked on Yes and the criteria column dissapeared (the name is the same, but the content is from the next column). I cannot add any fields, not even at the end. Is there any way to add the column at the beginning (where it used to be) or, at least, at the end? Hope you can help me! Thank you for all of your tutorials.
Hi Andreea, Did you make a backup of this database before you made your changes? Can you send me a copy of the database? If so, please send it in an e-mail to thefrugalcomputerguy@yahoo.com - Thanks.
Thank you for the videos, very helpful indeed, however I was looking for a video that would show me how to Auto-Open and then display in Full Screen a form within a database. I did not find it, is that possible in OpenOffice? Thanks!
Does anyone have experience getting leading 0s to stay on an address database. I have gotten so far using the videos but I am now stuck on entering zips
I have no idea if you are still monitoring responses here. I am getting a message straight away that no Java installation could be detected. I don't know what Java is, but there are so many Java products in the App Store I have no idea what I need to install. Please advise! Thank you.
Hi there. Please try using this link: www.java.com/en/download/manual.jsp because that's where I downloaded the Java needed. Download the 64 bit "offline' version and run the database program again. I hope that helps.
Thank you for a useful series of tutorials; I have worked through several of them. However, Base (Version: 6.4.7.2) will not open my new database due to absence of Java. The LibreOffice help files describe the problem but there is nothing of any use to help resolve it. Any advice?
Try Downloading java from here: java.com/en/download/manual.jsp
You may need to make sure LibreOffice can see it by choosing the version you just downloaded in:
Tools - Options - LibreOffice - Advanced - select Java runtime environment
@@MichaelsTechTutorials Thanks alot,I was facing this issue for a while.
Did you realize that this video series is now 11 ELEVEN years old?
It is nearly impossible to find current videos that actually work with current software whenever I look for it. But, in spite of ten years worth of advancements, and I watched LibreOffice go through some great changes, especially with their Writer,
YOUR BASE VIDEOS ARE STILL UP TO DATE!!!!!!!!
I want to let you know that I love that your videos are short, sweet and to the point. I don't think I have even given MS Access the time of day for over 25-30 years. Yet, yesterday, I was able to pick up Base, and using your videos, completely from scratch, design and build an application I wanted in just a few hours.
Your videos are short, sweet and to the point so I was able to go directly to the episode I needed to get every answer I needed when I needed it. I only had to Google one question and the answer was at the top of the first page in the summary.
I don't know if I'm praising you, which you deserve for your wonderful video series, or LibreOffice for being so consistent and keeping their Base software so backward compatible.
Have a great day and keep up the good work.
I appreciate you
Shabbat Shalom
If you want to build a Libre Office Base project, this is the spot. There are 94 videos that cover almost every thing you need to know. I taught myself to use Microsoft Access and spent many months developing a project 20 years ago. As I watch these videos they bring back the concepts and provide the steps I need to create a new project in Base an excellent program at a Frugal price. Thank you FRUGAL Computer Guy. Wish I had this info 20 years ago but You Tube didn't exist then (did it).
Thank You. These are not just the best LibreOffice Base tutorials, but the best tutorials, period. I have never seen anything complex explained so clearly yet simply. This guy is amazing.
91 vids of 11 min... That's 1001 minutes so I'm looking at 16 hours and 41 minutes...
I want to learn this program in one day! Thank you so much!
Then you're in luck - put on a pot of joe and get crackin. in less than a solar day you'll be an expert.
I really needed this series. I tried to learn databases a long time ago and got messed up with the multi table part and foreign keys. Just watched the short video on the primary and foreign keys and I knew I needed to watch the whole playlist on LubreOffice Base. I finally feel I will end up understanding it finally. Thank you! I see you have a lot of other great topics and I will be watching them as well. I feel a sense of relief already.
Okay I am back for the second time. The first time was to watch the necessary ones to accomplish my immediate goal. Ha. Now I am back for the overall training. Thank You! Your material is absolutely superior.
Thanks very much for making all your tutorial videos. They're excellent! It must have taken many hours planning, preparing, and recording them. The quality of information and manner of presentation are very professional. I have just given a donation via your web site. Thank you very much for your commitment.
+richardnz100 Hello Richard, Yes they did take a lot of time to plan, prepare, and record. I really appreciate my viewers and try to give them the best tutorials I can. Yes, I received the donation - Thank you. Receiving donations really means a lot to me because it shows me you got enough value out of my videos to make a donation. And I do appreciate the people who click the thumbs up and/or take the time to send a thank you comment too - Thanks for watching!
This man is a true legend. Thank you for your hard work!
This playlist is so useful to a beginner like myself. Even after 8 years, they do seem to be very accurate.
thank you so much...even after 10 years this is still important. God bless you
This entire playlist is super helpful, and it will probably save me in my IGCSE examinations
Wow! Such a useful series. It has just passed its fifth birthday but almost everything is still relevant, because of the way LO adds features but does not remove them.
As a Linux user by choice, but formerly trained on Ms Access I found the rest of LO intuitive but Base obscure in so many places.
I find it especially useful that you show exactly where to find each control on the page, as that is what I (personally) am having most trouble with.
Warmly
River~~
It's a fantastic collection of database videos you've made here, I've been following them with great pleasure, they've been very helpful, Thanks for the great work
Hi! Thank you so much for this!! This is super helpful
You are very welcome. Thank you for the kind words in both languages.
pretty well, i found best teacher here for start learning about Libre Base. Thankyou so much bro,,
Thanks Man I had IT Practicals u saved my life and my marks........i had no idea what to do about this practicals n i saw this video
As an IT student. I'm so glad I found you, where have you been!! I love all of your vids, I think you're underrated.
I really don't have a use for a program like this, but I was just curious about what it did, and you did a great job explaining how to use it and what it is for. This was a great tutorial.
Thanks.
Heartly salutations to you, good sir!
Great to see the continuation of the LibreOffice series.
KUDOS!
Wow! Thank you for the great tutorials. Very clear and step by step. In the process of importing my records from Access and making forms and reports into Libre. I've been a Word user since it was on a 360K floppy. It's horrible what Office and Windows have become. When my DB in Libre is set up, I'm done with MSOffice.
Thanks for sharing your knowledge with us! LibreOffice at least for my pc is much more easier to use and doesn't consume much space from my HD! I will definitively watch the rest of the playlist!
Very nice video tutorial, very well explained. Just a little advice: make playlist based on every application. Right now I would like to watch just the LibreOffice Base tutorials.
You can find the LibreOffice Playlist at:
th-cam.com/play/PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV.html
Thanks!
Hi Thanks for the straight forward, informative and clear instructions on how to build a data base.
Good eye to catch that! In the video, you will see that I try to save my table after typing in the last name of the second record, but before I typed in the first name (both required fields). LibreOffice incremented the auto value and tried to save the record (It couldn’t enter it at that time) after I typed in all required fields, I clicked save, it incremented (again) and added the autovalue to the record.
Thank you, all videos are of great value and information. Very professionally put together.
Thank you for explaining that it is only a front-end and that you are using the default!
I loved it. You're way better than my professor.
A little info on what a LibreOffice Base actually is - would be nice. Anyway, vid is cool
Nice tutorial. Clear and easy to see and follow . I look forward to watching more of them. Thanks for putting in the effort to make these available.
Thanks a lot for these newbie to professional tutorials .
Thank you, I'll try it. Again, thank you for your tutorials. I like your voice and delivery.
Really helpful my exam is tomorrow thank you
Good evening! I'm from Mozambique. I would like to thank you for the video, I really liked it.
Thalavaaa!! Your are great.. life saver thanks.
Thank you! That’s a great compliment. I’ve got a basic windows 7 home premium computer and the screen capture software I use is Microsoft Expression Screen Capture (It was free with windows 7, but I did have to download it separately).
Thank you so much!! I did not have ms office 365 but in school, we were supposed to do it...I found this as a good alternative but because of the java issue, I could not use it..thanks again!!
Actually, I don't have a complete plan (yet), so I can't say for sure how long this is going to be or what will be covered, but that's how all my series start. I have some idea's to work with and right now, it seems there may be a lot of videos, but we will have to wait and see...
This is an excellent Tutorial Series
Thank you so much , you helped me alot. Pls keep on providing
Fantastic!! I struggled a lot to make a data base (I'm not a computer guy, at all) untill I found your channel.
I love your pedagogy. In the past I tried some books but all of them or taught data base design from a rather teoretical view without specific software connection or explained how to use a software assuming one is already profiency in data base design.
With your material I've been introducing me in both subjects simultaneously.
I'm currently using LibreOffice 6; any chance you update the material to cover the new LO capabilities. Please.
PD: sorry for my english, I'm an spanish speaker so...
Thank you very much you did a great job explaining this.
You explain so clearly thanks!!!!
Your tutorials are wonderful.
Could you recreate them for the current version of Libreoffice?
Long series, huh? Oooo nnice... Can't wait! :)
This is great Feedback to hear. I'm using these videos for similar reasons. Thanks Frugal!
Thank you sir
This video clearly goes around the most obvious problem with Libre and OpenOffice base. Not being able to search fields on the form is so basic that Base is by no means a serious competitor to Microsoft Access - a developer simply can not make a user friendly GUI.
very professional and helpful videos! many thanks!
Thanks a lot... just what i needed for libreOffice Base
Haha I'm here 20 hours before my practicals haha
I've used your Calc and Writer tutorials to learn enough for me to get work. I am looking forward to using this series too. You provide a great service with your tutorials, they are the simplest and best series I've come across - free or paid.
What hardware-software do you use to produce your videos?
Thank you very much for this great tutorial!
Thanks, ill get my marks for this.
My request you to make a awesome tutorial on Calligra Plan as you did lot of awesome tutorial.. really thankful to you.
Thank You so Much, I've been reading for mouths now about how to use databases and have learned a lot. I'm A hands on, trial and error learner but man you have showed me a lots in a shorter time than reading and everyone still needs to read a lot of the apps. help intros but these tutorials will save you a lot of time,it has me Thanks again TheFrugalComputerGuy.com
I spent several years using MS Access. Now I'm 74 and want to use Base as much for sentimental reasons as anything. I'm 74 and using LO 4.3 on a win7 box. Two questions: (1) you say Base is only the front end of a db, but I see relationships, queries, wizards, report builders etc. (2) due to prior warnings, I've 'turned off' java. IN YOUR OPINION, should I 'reinstall' java? if so, what ver?
Gramps... Sharpsburg KY USA
Ma perchè in Italia non esistono persone come te che fanno Video cosi interessanti??? WHY??
Come posso fare a tradurre i tuoi video??? Grazie di esistere
Huh, looks like a great video series.
>Does pretty good for first 5 minutes
OK sweet, it's in an accent I can easily understand...
>employess
/me watches on with hopeful optimism...
Thank you sir Thank you sir
Thank you so much sir
These videos you have created are incredible. But for me,my eyes just gloss over when trying to learn. Sir can you point me to exactly which program within Libre Office i can use to create a phone number list and then alphabetize the list? Thank you very much.
why don't you use LibreOffice Calc? Set up columns with a name/title in the top row and fill in the information you have.
Suggested column name/titles; phone, last name, first name, street, city, zip, birthday, etc You can easily add information any time and sort by any column (last name) to put all in alpha order any time
@@robertr7707 Thank you very much. Thats exactly what i did, Took a while to figure out how but i did it! Thanks again
I love it how you say odb. :D
Hello i am new subscriber. How can i make a list of different doctors and results from blood tests all itemized. Are you still making BASE tutorials from new versions or are they all the same?
I am a senior and need help. Thank you Michael
Hi I was wondering if you could help me set up my data. I have two instructional works I want to compare. They have written similar steps in the instruction but there are differences. In addition, there are multiple components within each step. I was looking at your multiple tables video but am not sure if I could eventually make the correct relationships. For Table 1: I was thinking of creating 2 rows of Instructional Work #1 and then #2 and then giving each instruction work an ID; in the columns I was going to write out all the steps. But instead of writing the different components of each step as separate columns (like your work phone number, cell, home, etc) I was thinking I should create another table for each instructional step (Table 2). Then in Table 2 I would assign each row the instructional work ID so I could create a relationship between each table.
My question is: How do I create a unique ID? I don't have 2 variables like your phone number situation that together creates another unique situation that could become a new unique ID. I only have 2 instructional works like 2 employees.
Help!
-Kay
Hi, thanks a lot for the tutorial, your the way you explain things is very clear and makes it easy to learn it, just one thing, I can't find "odb00-employee-calc-table.ods" in your site (a few comments before you instructed someone to search for it "under Group 2 video 3"), can you post a url or may be point me in the right direction? Thanks again for all your hard and very effective work
Hello Mr. Frugal. I need to create a customer searchable database for issues they may face and possible solutions (which will come in the form of recommended books and/or activities). Does that make sense? Would LibreOffice Base be a good place to create that database? I get the sense that it can receive information (currently in Excel) but my main reason in switching to a database would be because the Excel list we have is clunky for our customers. Thank you for your advise.
Greetings! Yes, Libre Office Base this time, I’ve had a lot of requests for this topic. As with the other modules - there is a lot to it! This could be a long series...
App Hindi bolo please samj Nahi ATA hai
The primary index lacks the id number 1. Is this a bug of the wizard? I doubt is the default behavior of any SQL.
When I clicked save, and did not have all the required fields filled in, it tried to use the number 1 and could not. It moves on to number 2 - That is what happened to the number 1 in the video. Anytime you try and save a record without all the required fields filled in, you will loose an auto-populate number.
TheFrugalComputerGuy Thanks! So...basically a bug.
your video is good but when we enter data type as number or integer then while filling the table details that should not accpet charachters.. its accepting no & char both.. how?? can you reply?
Yes even i have doubt please conferm sir..🙏
Just a note that you probably know but isn't varchar (considering giant databases) less efficient speed wise than a fixed char (assuming that you can determine a decent fixed length) due to random access?
Probably no noticeable difference for even medium sized databases but it just bugged me a bit to hear you say "efficient" rather than highly convient and with a non-noticeable speed difference (though this is a tutorial on Libre's Base not on how computers work internally so...forgiven of course :))
Thank you, helped very much
6:27 TRIGGERED!!!!
Lol
bwahahha ... the times we live in
Question I'm making a data base for a Dog grooming business.....Should i make a separate table for the dogs?
Sorry - one last thing. My purpose is: I basically want to be able to make queries so I can compare the steps of both instructional works at the same time in the same form. Even if the steps of each instruction work exists in separate tables. I was thinking I could display the steps as those tables you showed underneath the form.
Is this possible?
Thanks! Very nice and helpfull
Please, today, 2020, do you still recommend the use of Base as a SQL database? Is it updated to nowadays standards? Thanks!
Hello Michael, I want to create a new table with a primary key as a series which is a combination of text + | + Integer (5001) for example. How can I achieve this? Please help me here.
have you done any video on how to add audio to a slide show presentation .
I have to monitor payments and debt for 90 users. Which part of LO would serve the purpose?
This LibreOffice Base looks very much like MS Access, with some interesting improved features.
but can u save the database in documents?
I notice you retyped the whole calc spreadsheet by hand... and made some errors.
Isn't there a way to import data from another LibreOffice app into the database?
That would be slick, esp. for my 400 plus entry database!
I see The Frugal Guy doesn't answer questions. Anyone else know the answer?
Anyone?
Bueller?
see that thefrugalcomputerguy.com/grouppg.php?ser=15&grp=2
Even if the steps of each instruction work exists in separate tables.
I meant to say: Even if the components of each step of both instruction works exist in separate tables. (So Table 1 doesn't get crowded and messy looking like your phone number situation)
hi, great video.
have one question - how can i sort my columns in design view?
FYI, I'm using LibreOffice 6.3.3.2. To get sbase to work, I had to install the following. (I asked for libreoffice-base, but had to add sdbc. I threw in the other database connectors (mysql, hsqldb, and postgresql), and the rest got pulled in as dependencies.)
libtommath1:amd64
libfbclient2:amd64
libib-util:amd64
firebird3.0-server-core:amd64
firebird3.0-utils:amd64
libreoffice-base-drivers:amd64
libreoffice-base:amd64
libreoffice-evolution:amd64
libreoffice-java-common:all
libreoffice-sdbc-firebird:amd64
libreoffice-dmaths:all
libreoffice-templates:all
libhsqldb1.8.0-java:all
libreoffice-sdbc-mysql:amd64
libreoffice-mysql-connector:amd64
libreoffice-sdbc-hsqldb:amd64
libreoffice-sdbc-postgresql:amd64
(Firebird was pulled in as one of the dependencies.)
I am a mac user and what to create a database with photos for real estate and a comprehensive
directory all centered around photos. Pls direct me to training material which cover the topics. Thanks
Hey, I really enjoy your work, you make it look so nice and easy.
I've come across 1 problem: in my data base i wanted to change the field type which appeared on the field name 'Criteria" from Number to Integer and it said "the column could not be changed, should the column be deleted and the new format appended?" I clicked on Yes and the criteria column dissapeared (the name is the same, but the content is from the next column).
I cannot add any fields, not even at the end. Is there any way to add the column at the beginning (where it used to be) or, at least, at the end? Hope you can help me! Thank you for all of your tutorials.
Hi Andreea,
Did you make a backup of this database before you made your changes? Can you send me a copy of the database? If so, please send it in an e-mail to thefrugalcomputerguy@yahoo.com - Thanks.
Wow, I recognise that voice... are you from Canada or once lived there?
Why does the ID Number go from 0 to 2 ?
It starts from 1 in my pc
Ronny, he answers this in a comment above which starts with "Good eye to catch that!"
Thanks, cool video!
Thanks I learned a lot !!!
thankyou for good basic tutorial that I needed, but it says I need 64 bit?
Thank you for the videos, very helpful indeed, however I was looking for a video that would show me how to Auto-Open and then display in Full Screen a form within a database. I did not find it, is that possible in OpenOffice? Thanks!
Its really a biggest help
Does anyone have experience getting leading 0s to stay on an address database. I have gotten so far using the videos but I am now stuck on entering zips
if you set the zip field to text instead of numeric, the 0's will be treated as characters and stay where you want them.
You're Welcome!
Hey, After opening the save table i am not able to insert the data . The option isn't available.🙄 Help me out.
There is a problem with "subscription"...… It clears and don't remains "ON".....
I have no idea if you are still monitoring responses here. I am getting a message straight away that no Java installation could be detected. I don't know what Java is, but there are so many Java products in the App Store I have no idea what I need to install. Please advise! Thank you.
Hi there. Please try using this link: www.java.com/en/download/manual.jsp
because that's where I downloaded the Java needed. Download the 64 bit "offline' version and run the database program again. I hope that helps.
Can u tell me ,how can I print a database file done using design view in OpenOffice Base?
Hello, I can not edit the field properties of the table after I created the table, and save it. Do you know how I can get access to modify the fields?