LibreOffice Base (94) odb94 MySQL Searchform
Автор: MichaelsTechTutorials
Загружено: 2015-03-07
Просмотров: 11095
We complete the LibreOffice Base form, that searches for employees on a MySQL database, that we started in the previous video.
First we add a dropdowns to the Department and Group text boxes in the search criteria. Then we change the Department-ID and Group-ID to Department and Group in the subform and reformat the Start Date in the subform.
We add the variable link fields for the SQL join and add the SQL from odb57 into the SQL command area.
We test the form and find that most of the SQL is good, but the MySQL SQL is different than the HSQLDB SQL for upper case and concatenate. We need to use UCASE instead of UPPER to get our data to the upper case and CONCAT() in place of || to concatenate the fields together.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: