1. I get the space value 2. To make the value NULL, just erase the input inside the table 3. How do you make somebody's department value as ''? (the empty value, and not null)
Found the answer. You can set it using an SQL command. UPDATE "tbl_Employees" SET "Department" = '' WHERE "employee-ID" = 16; UPDATE "tbl_Employees" SET "Department" = NULL WHERE "employee-ID" = 16; Is it possible to do the same inside the table edit GUI area, and not via an SQL command?
Question: Is there a way to automatically update a field after a date field has been updated? LastV (date), NextV (date = lastV + 365). Thanks in advance.
+Adrian Dorland You can download odb22-Qry-Wildcards.odb (for free) from my website at thefrugalcomputerguy.com/libreoffice-base then follow along with the video!
+TheFrugalComputerGuy Hi I have been following along and its making more sense this time round but i just wanted to know how you made the changes to the table. Because when I remove the data from the spreadsheet and add the 2 spaces to 2 of the department fields i get the result of 4 records with NULL values and 2 records with 2 spaces. I wanted to know how you got the 2 records that use the = '' Thank you
+Adrian Dorland I too wanted to know how it was done, so I did some research, and found the answer. I won't post it here out of respect for the sequence of the tutorials. If you would like to know, feel free to contact me privately.
Very good!
I know this is 9 years old, but I'm confused ... how did you reformat the single line sql to multiple lines?
1. I get the space value
2. To make the value NULL, just erase the input inside the table
3. How do you make somebody's department value as ''? (the empty value, and not null)
Found the answer. You can set it using an SQL command.
UPDATE "tbl_Employees"
SET "Department" = ''
WHERE "employee-ID" = 16;
UPDATE "tbl_Employees"
SET "Department" = NULL
WHERE "employee-ID" = 16;
Is it possible to do the same inside the table edit GUI area, and not via an SQL command?
Question: Is there a way to automatically update a field after a date field has been updated? LastV (date), NextV (date = lastV + 365). Thanks in advance.
Could you do a step by step guide of how to create the table with the values that you had made so i can replicate it for this tutorial please.
+Adrian Dorland You can download odb22-Qry-Wildcards.odb (for free) from my website at thefrugalcomputerguy.com/libreoffice-base then follow along with the video!
+TheFrugalComputerGuy Hi I have been following along and its making more sense this time round but i just wanted to know how you made the changes to the table. Because when I remove the data from the spreadsheet and add the 2 spaces to 2 of the department fields i get the result of 4 records with NULL values and 2 records with 2 spaces. I wanted to know how you got the 2 records that use the = '' Thank you
+Adrian Dorland I too wanted to know how it was done, so I did some research, and found the answer. I won't post it here out of respect for the sequence of the tutorials. If you would like to know, feel free to contact me privately.
Null is default value to indicate Nothing.
Thanks..