?
Solved

Need to add a column to MySql DataBase, where I can track the last user who made changes to the information.VB.NET

Posted on 2010-09-09
2
Medium Priority
?
321 Views
Last Modified: 2013-12-25
I have a programm in VB.NET   that requires a correct log in, in order to access to it. Once the user has accesed to it, he can make changes to the information. I want to have a column where I can check who was the last that modified that information.


Thanks.
0
Comment
Question by:zandizza
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
DalHorinek earned 2000 total points
ID: 33642294
I guess you have an id of your users. So add a column last_id_user to the information table and on every change do something like

update information_table set last_id_user = <id_of_current_user>

Maybe I don't understand well the question.
0
 

Author Comment

by:zandizza
ID: 33642304
yes, that is exactly what I am looking for. To set a record of everyone who has update information.
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month13 days, 6 hours left to enroll

777 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