7:22 introduces table aliases begs the question though... the DB engine reads left to right top to bottom so the engine has to get to the FROM statement before it knows the aliases so it is going to slow down the search, isn't it? And then has to go back to the top of the query... that would put some extra cpu cycles on the query.
Not quite. The parser checks to see if the identifier corresponds to a table, and if it does not, it simply makes a symbol table entry with no binding. Later, when it encounters the ALIAS to can go back and bind the alias to the correct table by completing the symbol table entry. Then all it has to do during final processing is verify all symbol table entries are complete, which is an O(1) operation if your symbol table is properly implemented.
10:40 confirmed in LOB 5.1. User comments in SQL are not saved. :( and unfortunately in the video he didn't go back and show whether his comments were saved between design view and sql view.
I need lessons explain writing code I want to convert from Microsoft Office to Libre but .. I need to code transmits information from the fields of text in access lists to text boxes in exact Word Page the code opened when button clicked can you help me in that , please
Thank you for the comment. I think you want to know about creating macros or using LibreOffice Basic. That is a topic in itself and will not be covered in this LibreOffice Base Tutorial series.
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
These videos are awsome
Thanks so much !👌
you're a wondefull guy. it helps me very much
7:00 designing queries works well with not only one table but *
Very good!
7:22 introduces table aliases begs the question though... the DB engine reads left to right top to bottom so the engine has to get to the FROM statement before it knows the aliases so it is going to slow down the search, isn't it? And then has to go back to the top of the query... that would put some extra cpu cycles on the query.
Not quite. The parser checks to see if the identifier corresponds to a table, and if it does not, it simply makes a symbol table entry with no binding. Later, when it encounters the ALIAS to can go back and bind the alias to the correct table by completing the symbol table entry. Then all it has to do during final processing is verify all symbol table entries are complete, which is an O(1) operation if your symbol table is properly implemented.
10:40 confirmed in LOB 5.1. User comments in SQL are not saved. :( and unfortunately in the video he didn't go back and show whether his comments were saved between design view and sql view.
excellent
Can you tell please is it possible to download all of your data,tables with names,gender etc...or not? If yes, where I can download this ?
LibreOffice Base downloads can be found here:
www.thefrugalcomputerguy.com/libreoffice-base/index.php
I need lessons explain writing code
I want to convert from Microsoft Office to Libre but ..
I need to code transmits information from the fields of text in access lists to text boxes in exact Word Page the code opened when button clicked
can you help me in that , please
Thank you for the comment. I think you want to know about creating macros or using LibreOffice Basic. That is a topic in itself and will not be covered in this LibreOffice Base Tutorial series.