Solved

Changing a Database Field on a Timer

Posted on 2011-09-25
2
143 Views
Last Modified: 2012-05-12
Hi, I need to change a field in a sql database on the 1st day of every month, bascially resetting a flag. I have 5 users in my system so after the field has been changed by the first logged in user, I need to check it doesnt get reset again until the 1st of the following month.

Hope this makes sense, any help is appreciated,

Thanks
0
Comment
Question by:SCOTT78
2 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 75 total points
ID: 36595774
Add a field in the same table or in another table to record the month.

When a user login, check if that if that field contains the current month.

If yes, do nothing.

If no, they this is the first logging in the month. Reset your flag and then update the month to the current one.

In fact, depending on how you use your flag, the field with the month could become your flag.
0
 

Author Closing Comment

by:SCOTT78
ID: 36598969
Simple method, just what I neeed. Many Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Limiting string to two deciamls 18 49
Check if number is currency 15 31
Protecting vb6 & .Net code Obfuscation 18 94
How to remove double quotes from a string in VB.Net 5 37
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
A short film showing how OnPage and Connectwise integration works.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now