I concur with most of these comments: your patient and thorough, but not overly descriptive tutorials are perfect. There are many who should take a lesson from your clear diction and measured speech. ( Never an "...uummm.." to be heard, very refreshing..!)
Thank you sir . Ur explanation is fab i sure hope to see u doing this good job of teaching people and spreading education . Could u explain how to run Query in SQL View pls reply to it ASAP
Lets say, you have drop down box for first name and phone number in the employee form. Each employee in the table has more than one contact no. If I select 'Nancy' from the first name drop down box then when I go to Phone no. drop down box is it possible to get only those contact nos. which belongs to 'Nancy' ? What SQL code or type of query is required to get this type of output?
Hello! very good explanation! Can you help? I have a database (base.odb) where field name of the table data have accents! set up field name varchar_ignorasecase returns only uppercase and lowercase data with accents not return. It can creating a sql case-insensitive (varchar_ignorasecase = ok), accent-insensitive? Other DBMS's has COLLATION equal to MySQL, MySQL-Server, Base has Collation? Hug!
+Marcos Paulo (FIÃO) Hello Marcos, LibreOffice Base uses the HSQLDB database. I would suggest you check out the HSQLDB User Guide found at: hsqldb.org/doc/2.0/guide/index.html Regards, Michael
Can you believe that 10 years later your video is still helping people like me learn to make Queries? Thank you, you are a very gifted instructor.
I concur with most of these comments: your patient and thorough, but not overly descriptive tutorials are perfect. There are many who should take a lesson from your clear diction and measured speech. ( Never an "...uummm.." to be heard, very refreshing..!)
Sir, I am appreciating your sincere effort, though the lesson is hard your explanation is easy especially the definition of SQL..Thanks
Thanks a bunch really. I have a school project to submit and tomorrow is the last day lol.
Thanks for the encouraging comment!
please do more videos on Libre Office
This is really very helpful.
This videos are great, tnx
Thank you sir . Ur explanation is fab i sure hope to see u doing this good job of teaching people and spreading education .
Could u explain how to run Query in SQL View pls reply to it ASAP
Thank you soo much for this!! exactly what I needed.
nice explanation.Thanx a lot!
thank you for your videos!!! Great job!
Great; easy to understand!
this video is 8 years old and now i am realizing how much the technology has moved forward
Very, very good!
Lets say, you have drop down box for first name and phone number in the employee form. Each employee in the table has more than one contact no. If I select 'Nancy' from the first name drop down box then when I go to Phone no. drop down box is it possible to get only those contact nos. which belongs to 'Nancy' ? What SQL code or type of query is required to get this type of output?
Really useful
Excellent
Nice job :)
Hello! I would like to know how did you format it to make it easier to read it? is there an specifc command or short cut?
I love the part where he says "qwuries."
How to format that SQL code ? I havent figured that one
what shortcut key do you use to reformat view in SQL?
How do I sync libre office calc to google sheets?
i can't add a field to my Query in Example View
this video makes bright feature
fantastic explaination thank you
thanks
Hello! very good explanation!
Can you help?
I have a database (base.odb) where field name of the table data have accents!
set up field name varchar_ignorasecase returns only uppercase and lowercase data with accents not return.
It can creating a sql case-insensitive (varchar_ignorasecase = ok), accent-insensitive?
Other DBMS's has COLLATION equal to MySQL, MySQL-Server, Base has Collation?
Hug!
+Marcos Paulo (FIÃO) Hello Marcos,
LibreOffice Base uses the HSQLDB database. I would suggest you check out the HSQLDB User Guide found at: hsqldb.org/doc/2.0/guide/index.html
Regards,
Michael
Who really needs to save a query, when using the filter options works just as well? It's not like you search for the same thing every day.
Yes 10 year
What about WEB query????
Can anyone here tell me how to reformat the sql view instead of single line? ???
Check out video (21) SQL Where Part 2 - I show how I'm reformatting the SQL at 5:40
who is watching this 2021 for IT practicals??
haha me lol
video is too slow