Skip to Content
Last modified by Danniar Firdausy on 2024/09/18 20:02
From version 23.6
edited by Danniar Firdausy
on 2024/09/18 20:02
Change comment: There is no comment for this version
To version 23.7
edited by Danniar Firdausy
on 2024/09/18 20:02
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,7 +1,5 @@
1 1  {{container}}{{container layoutStyle="columns"}}(((
2 2  
3 -In the previous [[microlearning>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Database connectivity.intermediate-database-connectivity-sql-query||target="blank"]] we discussed the fundamentals of SQL queries. In this microlearning, we will learn how you could update the record(s) in the database the moment after you have read the information from the database. This functionality can help you update a status field to ensure you won't keep reading the same record(s) repeatedly.
4 -
5 5  In our previous [[microlearning>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Database connectivity.intermediate-database-connectivity-sql-query||target="blank"]], we explored the basics of SQL queries. Now, we will take it a step further by learning how to update database records immediately after retrieving them. This approach is useful for managing statuses, ensuring you do not repeatedly read, or retrieve, the same records. Let's dive into how this functionality works and how to implement it within eMagiz.
6 6  
7 7  Should you have any questions, please get in touch with [[academy@emagiz.com>>mailto:academy@emagiz.com]].