Jump to content

Auto update Database Table value when time expires


Zinn
 Share

Recommended Posts

Hello Coding Masters,

Thank you for reading my post. 

I need your help if if it's possible that Database table value will automatically update the value when time expires? 

Sample, If now time is is between ENTRYTime  and CLOSE Time, table value will automatically update if time set expires? 

Enabled value is = 0 on my table
Disabled value is = 0 on my table. 

But I have someone close to me suggested if its possible to set these automatically? 

image.png.cb1e2904c1ed4946deb301688453cf4c.png

Thank you so much for your feedback.

Link to comment
Share on other sites

Thank you so much @Barand Sir, Definitly try this one and let you know. 

The thing is, I get this value (1) of enabled  if users will try to submit attendance. 

And if that user is late, she will no longer be able to submit attendance. 

Thank you. 

Link to comment
Share on other sites

2 minutes ago, Zinn said:

Thank you so much @Barand Sir, Definitly try this one and let you know. 

The thing is, I get this value (1) of enabled  if users will try to submit attendance. 

And if that user is late, she will no longer be able to submit attendance. 

Thank you. 

Barand's point is that you don't need the enabled field at all. 

Your application should allow submissions when the current date/time is between entrytime and closetime. 
At any other time, it should not allow submissions. 

Showing which items are available is a problem for the client web page - Javascript's much better at that sort of thing.  (Of course, your server-side Application still needs to check those date/times!)

Having databases try to update themselves in near-real time is a pretty difficult undertaking and assumes that your database is always, always available and working and properly.  Take it from a 30+ year professional ...   100% Availability is a Myth. 

Regards, 
   Phill  W.

 

 

 

Link to comment
Share on other sites

Hello @Phi11W

Yes correct! 

I got Barand's idea and I will follow this best idea than my complex one.

You have a good point and thank you for your initiative.

Appreciate your help guys.

I will update here once everything set on my end.

Thank you so much. 

Regards,
Zin

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.