THANKS BUDDY YOU SAVED MY LIFE. TODAY I HAD A PRACTICAL AND I DIDNT KNOW HOW TO USE SQL BUT AFTER WATCHING YOUR DETAILED CLIP I FEEL LIKE I CAN TOP ANY PRACTICAL EXAM RELATED TO SQL. THANKS BUDDY YOU REALLY SAVED ME FROM A GRAVE DANGER
As someone working for a charity and looking for database solutions to how we handle our information your videos have been immensely useful. Thank you so much for putting what could be a paid-for service on the Internet for free; it really makes a difference to people and organisations like mine.
First, let me say thank you for this tutorial series. I know it takes a huge amount of work & time to prepare this. I watched a lot of online tutorials, and I can say that you are a very talented teacher.
Thanks, I’ve had some requests from some people that don’t speak English; asking if I would add subtitles (in English) they would be able to translate them to their own language. I hope it works for them. As well as helping out the English speaking viewers….
Hello again! Today seems to be a good day for me on TH-cam. I'm on my Linux system and did a bit of tweaking with the Firefox add-ons and YT has provided HTML 5 so I opted for that too. BTW Mint 14 isn't LTS - it's 13 that's LTS. I'm using Mint Olivia - which is 15. Let's see if the current stability is a keeper for Google/TH-cam.
That right Mint 13 is the LTS - I was having some problems with my mouse with that version, tried a couple of other versions and realized I had the same mouse problem (I think it is a Debian Problem). So I decided to go back to Mint (and put in the wrong disc). Reinstalling every 4 years is good, because it forces me to clean up my files and get rid of the junk I don’t really need. Reinstalling every 6 months or every year is way too often for me.
Hi again. Google and TH-cam in their wisdom to innovate and renovate seem to be causing problems my desktop but all works well on the iPod. So, HELLO! from the iPod!!! :)
The sql code in LibreOffice kinda sucks, I usually do my tables in comand Line and I usually put singles quotes, but the doubles quotes works too. (Not in LibreOffice). Other - SELECT COLUMN column FROM TABLE table; -> thats not able too in LibreOffice and it does not shows us where's the error is, and many other... So, forget the sql code in LibreOffice, it will only give you headache. But thank you for your videos, it's helping me a lot ;)
You’ve got me curious now - What distro do you use? Last night, I tried it on Linux Mint 14 LTS (I’m dual booting) and I was able to play one - but since you say it’s ‘touch and go’ it could been one of the ‘go’ periods. I wouldn’t call it a thorough test (trying 1 video once) I just didn’t have time for anything more. I'll try it again tonight.
I am trying to make a form in Base and I had the following question that I still don't know the answer to. I have three fields on the form taken from the customers table. They are: Client Code; Own name; Nickname. I want to do the following: When placing the number corresponding to the "Customer code" in the form, the fields "First Name"; and "Nickname" are filled in automatically. I would like to thank those who are advanced in Base for all their help.
May I ask you a question that might also help other viewers? I am using LibreOffice 4.4.2.2. I use Base as a front-end to manage a MySQL database that resides on a web-server running phpMyAdmin. I connected to the database using JDBC using the connector in the archive mysql-connector-java-5.1.35-bin.jar. Most features work just as in your tutorials, but I have two issues so far: 1- The MySQL syntax is different than the one in your videos. Question is: what determines the SQL syntax used by LibreOffice? Is it the connector, the LibreOffice version, or simply the SQL syntax used by phpMyAdmin on the server? For instance, when creating a Query (QBE), then switching to Design View: instead of being within brackets, a field named "ID" in a table named "tbl_Members" appears as: `tbl_Members`.`ID` (name of the table between ` followed by a period then the name of the field between ` 2- I can't save the relationships created in Base (seems like Base and the server don't talk to each other in that respect, but tables, forms, queries work). Any ideas? Thank you so much in advance. Your tutorial series are incredible and are life-saver for many of us! Thank you for your contribution to the Open Source effort!!
Rfster900 Hello Rfster900 - I do address this issue in video 94 - th-cam.com/video/I8OY5OWUKZE/w-d-xo.html I try and use the same query for MySQL that I used for the HSQLDB query and it doesn't work properly. I ended up going the the MySQL site and checking the commands and use the proper MySQL commands in my query to get things to work.
TheFrugalComputerGuy Thank you for pointing out that you encountered the same issue in video 94 which I just watched. (As I go through the series, I try repeating your operations in parallel on a test Database I created on a webserver_ this help the learning process for me.) Indeed, the server runs MySQL version 5.1.73 which should explain the difference in syntax. In regards to my 2nd issue (relationships not carrying through between LibreOffice Base and the webserver), I think I found the answer: by default, the server uses MyISAM storage engine which does not support foreign keys. I did try to create tables using InnoDB instead, and the relationships seem to be maintained between Base and the server. Thank you again for these great tutorial series!
Hello again! This time I'm on Windows :( It seems that Google in its supreme omniscience is neglecting Linux. Things seem to work well on Windows but not Linux - it's touch and go with Linux. I don't know whether it's because of our lords and masters at Google or perhaps the Flash Player... Let's see how Google/TH-cam will deal with the chaos it's causing. On Linux, ALL other video sharing sites work fine but NOT TH-cam :(
THANKS BUDDY YOU SAVED MY LIFE. TODAY I HAD A PRACTICAL AND I DIDNT KNOW HOW TO USE SQL BUT AFTER WATCHING YOUR DETAILED CLIP I FEEL LIKE I CAN TOP ANY PRACTICAL EXAM RELATED TO SQL. THANKS BUDDY YOU REALLY SAVED ME FROM A GRAVE DANGER
This is the crucial steps you face most of the time, Thanks you to
teach us the best way, before face any frustrated situations.
As someone working for a charity and looking for database solutions to how we handle our information your videos have been immensely useful. Thank you so much for putting what could be a paid-for service on the Internet for free; it really makes a difference to people and organisations like mine.
First, let me say thank you for this tutorial series. I know it takes a huge amount of work & time to prepare this. I watched a lot of online tutorials, and I can say that you are a very talented teacher.
Thanks, I’ve had some requests from some people that don’t speak English; asking if I would add subtitles (in English) they would be able to translate them to their own language. I hope it works for them. As well as helping out the English speaking viewers….
I’ve had a few frustrations myself with some of the Goolge/TH-cam “improvements” - I’m glad you found a work around.
Hello again! Today seems to be a good day for me on TH-cam. I'm on my Linux system and did a bit of tweaking with the Firefox add-ons and YT has provided HTML 5 so I opted for that too. BTW Mint 14 isn't LTS - it's 13 that's LTS. I'm using Mint Olivia - which is 15. Let's see if the current stability is a keeper for Google/TH-cam.
That right Mint 13 is the LTS - I was having some problems with my mouse with that version, tried a couple of other versions and realized I had the same mouse problem (I think it is a Debian Problem). So I decided to go back to Mint (and put in the wrong disc). Reinstalling every 4 years is good, because it forces me to clean up my files and get rid of the junk I don’t really need. Reinstalling every 6 months or every year is way too often for me.
Hi again. Google and TH-cam in their wisdom to innovate and renovate seem to be causing problems my desktop but all works well on the iPod. So, HELLO! from the iPod!!! :)
The sql code in LibreOffice kinda sucks, I usually do my tables in comand Line and I usually put singles quotes, but the doubles quotes works too. (Not in LibreOffice).
Other - SELECT COLUMN column FROM TABLE table; -> thats not able too in LibreOffice and it does not shows us where's the error is, and many other...
So, forget the sql code in LibreOffice, it will only give you headache.
But thank you for your videos, it's helping me a lot ;)
You’ve got me curious now - What distro do you use? Last night, I tried it on Linux Mint 14 LTS (I’m dual booting) and I was able to play one - but since you say it’s ‘touch and go’ it could been one of the ‘go’ periods. I wouldn’t call it a thorough test (trying 1 video once) I just didn’t have time for anything more. I'll try it again tonight.
I am trying to make a form in Base and I had the following question that I still don't know the answer to.
I have three fields on the form taken from the customers table. They are: Client Code; Own name; Nickname.
I want to do the following: When placing the number corresponding to the "Customer code" in the form, the fields "First Name"; and "Nickname" are filled in automatically.
I would like to thank those who are advanced in Base for all their help.
Excelent!
May I ask you a question that might also help other viewers? I am using LibreOffice 4.4.2.2. I use Base as a front-end to manage a MySQL database that resides on a web-server running phpMyAdmin. I connected to the database using JDBC using the connector in the archive mysql-connector-java-5.1.35-bin.jar.
Most features work just as in your tutorials, but I have two issues so far:
1- The MySQL syntax is different than the one in your videos. Question is: what determines the SQL syntax used by LibreOffice? Is it the connector, the LibreOffice version, or simply the SQL syntax used by phpMyAdmin on the server?
For instance, when creating a Query (QBE), then switching to Design View: instead of being within brackets, a field named "ID" in a table named "tbl_Members" appears as: `tbl_Members`.`ID` (name of the table between ` followed by a period then the name of the field between `
2- I can't save the relationships created in Base (seems like Base and the server don't talk to each other in that respect, but tables, forms, queries work). Any ideas?
Thank you so much in advance. Your tutorial series are incredible and are life-saver for many of us! Thank you for your contribution to the Open Source effort!!
Rfster900 Hello Rfster900 - I do address this issue in video 94 - th-cam.com/video/I8OY5OWUKZE/w-d-xo.html I try and use the same query for MySQL that I used for the HSQLDB query and it doesn't work properly. I ended up going the the MySQL site and checking the commands and use the proper MySQL commands in my query to get things to work.
TheFrugalComputerGuy Thank you for pointing out that you encountered the same issue in video 94 which I just watched. (As I go through the series, I try repeating your operations in parallel on a test Database I created on a webserver_ this help the learning process for me.)
Indeed, the server runs MySQL version 5.1.73 which should explain the difference in syntax.
In regards to my 2nd issue (relationships not carrying through between LibreOffice Base and the webserver), I think I found the answer: by default, the server uses MyISAM storage engine which does not support foreign keys. I did try to create tables using InnoDB instead, and the relationships seem to be maintained between Base and the server.
Thank you again for these great tutorial series!
Parhaps using amara.org to do the translation might be a good solution. Thank you for all the videos, they are fantastic.
Thanks for the suggestion - I will check out amara.org
Hello again! This time I'm on Windows :( It seems that Google in its supreme omniscience is neglecting Linux. Things seem to work well on Windows but not Linux - it's touch and go with Linux. I don't know whether it's because of our lords and masters at Google or perhaps the Flash Player... Let's see how Google/TH-cam will deal with the chaos it's causing. On Linux, ALL other video sharing sites work fine but NOT TH-cam :(