I appreciate the information. Migrating from MS Access isn’t as simple as I thought it would be. Tinkering with both LibreOffice and SQL server, hoping both will pay off in the end
How did you construct the txt files? Is there a script or something that extracts the data from Calc and creates the txt file? If not.... Why isn't it easier to just type in the phone numbers to the new table directly? If you have to type up the txt file, that includes the phone number. Seems easier to just type it in the table. This seems like flying east around the world to go west 10 miles
This was the method, I looking for from the beginning to insert data into Table, I was wondering How SQL miss the original CLI methods. There are some difference between MySQL as HSQL, One is that HSQL (LibreOffice Base) Use : . Double Quote ( " ) to identify column/table name. & . Single Quote ( ' ) to Identify value Thanks...
+Dennis G Daniels Hello Dennis, Yes, there are some issues using LOB 5.x I know that some of them have already been reported. NO, I do not have any Udemy class, I do not charge $40 these lessons are all free. I am Not Michail Ananiadis he is a fraud, if you know how I can get my videos removed from the site (or at least set the price to $0) please let me know.
+Dennis G Daniels Thanks for letting me know it was out there. Looking around the internet, it seems Udemy does that a lot (takes other peoples work and claims it as their own - hiding watermarks and the like). Thanks for contacting them, I have tried to contact them too.
Thanks for this series, I am used to MS Access and this helps with the differences. I am having trouble with an calculation (Expression) in a query it wont recognize a null value as 0, do you have a video on calculations/expressions?
Man, this one lesson was hard to follow. I had error every time I wanted to run the SQL. Then I realized I have to refresh, then, at the end, I got lost on why I can erase the phone number list.
+Adrian Dorland I’m sorry you are having troubles following along with the tutorial series. The purpose of doing things the way I did; was to introduce the viewer to the different techniques available for LibreOffice Base. This series more of a “Here is what is available” over “This is how to do it” - Meaning it is meant to introduce you to the tools and techniques and show how they are used in different situations, then it is up to you to decide which tools are best for you to use for your situation.
TheFrugalComputerGuy Its ok your videos and tutorial are great its just my understanding but i am getting there!! Thank you for the hard work you have put into making these videos for us to learn from.
I appreciate the information. Migrating from MS Access isn’t as simple as I thought it would be. Tinkering with both LibreOffice and SQL server, hoping both will pay off in the end
The one thing I was missing was the "Show output of "select" statements" checkbox. Thanks for showing that!
How did you construct the txt files? Is there a script or something that extracts the data from Calc and creates the txt file? If not.... Why isn't it easier to just type in the phone numbers to the new table directly? If you have to type up the txt file, that includes the phone number. Seems easier to just type it in the table. This seems like flying east around the world to go west 10 miles
All right!
Thank you
This was the method, I looking for from the beginning to insert data into Table,
I was wondering How SQL miss the original CLI methods.
There are some difference between MySQL as HSQL,
One is that HSQL (LibreOffice Base) Use :
. Double Quote ( " ) to identify column/table name. &
. Single Quote ( ' ) to Identify value
Thanks...
FYI, LOB 5.x barfs on SQL commands that have spaces/returns. 7: Unexpected token: in statement [] ... FWIW, I came here is from your Udemy class...
+Dennis G Daniels Hello Dennis, Yes, there are some issues using LOB 5.x I know that some of them have already been reported. NO, I do not have any Udemy class, I do not charge $40 these lessons are all free. I am Not Michail Ananiadis he is a fraud, if you know how I can get my videos removed from the site (or at least set the price to $0) please let me know.
+Dennis G Daniels Thanks for letting me know it was out there. Looking around the internet, it seems Udemy does that a lot (takes other peoples work and claims it as their own - hiding watermarks and the like). Thanks for contacting them, I have tried to contact them too.
Thanks for this series, I am used to MS Access and this helps with the differences. I am having trouble with an calculation (Expression) in a query it wont recognize a null value as 0, do you have a video on calculations/expressions?
Man, this one lesson was hard to follow. I had error every time I wanted to run the SQL. Then I realized I have to refresh, then, at the end, I got lost on why I can erase the phone number list.
Please, how to use WEB query?
You make to many changes to your tables and it is hard to keep up. Correct Mistakes Start From Scratch Showing New Changes
+Adrian Dorland I’m sorry you are having troubles following along with the tutorial series.
The purpose of doing things the way I did; was to introduce the viewer to the different techniques available for LibreOffice Base.
This series more of a “Here is what is available” over “This is how to do it” - Meaning it is meant to introduce you to the tools and techniques and show how they are used in different situations, then it is up to you to decide which tools are best for you to use for your situation.
TheFrugalComputerGuy Its ok your videos and tutorial are great its just my understanding but i am getting there!! Thank you for the hard work you have put into making these videos for us to learn from.