Good brothers, now have something to consult!

Inadvertently won the company attendance database user name and password, and then do the program of a modified attendance record, including attendance record to add and delete,
The question now is, after I modify the database, then the results of a query is to modify a success, such as the new increase the clock in Y X days, but I don't know what circumstance, the database will be automatically rolled back, the new attendance record Y X days gone, back to modify the appearance of the former,
Roll back the time length is differ, sometimes for a few minutes, sometimes for hours,

I use a program, or directly in the enterprise manager change, the result is the same,

Please help to analysis what reason be?

Solve the successful, Shared code or offer you crack "central" attendance machine, the method of

CodePudding user response:

Query log to see see!

CodePudding user response:

reference 1st floor abclm response:

query log to see see!

Not too familiar, can consult how to query log?

CodePudding user response:

Transaction commit, cannot be rolled back, more can't "automatically", do you not have a password, open a trace and see what happened after you modify the database

CodePudding user response:

Whether this problem is worth exploring, attendance system setting function, from modification?

CodePudding user response:

You modify the attendance system is just on the backend database operations.

Someone else's specific how to implement the system of check on work attendance, you know not the forehead?

Perhaps at the front desk system in read attendance data submission, to cover your modified frontal ~

After I read the attendance machine reception of data, for example, write to the database, the next time I'm not from the last reading place, but from go up a little time before reading, duplicate data in reading, writing not cover you? ,,,,,,

Of course there are many other possible

CodePudding user response:

Handle attendance procedure done, for example, they used the schedule of two related, use a timer to check these two tables have redundant data, with the removal of redundant data, and added a table, you only see what I mean?
Methods: open event detector, tracking log, check whether deleted, rather than a rollback.

CodePudding user response:

Thank you for your answer, I'll try it!

This company's attendance system works:
The front is a attendance machine, ring in data storage, and then attendance machine manufacturers supporting the attendance management software, software to download data to essentially a machine of function, the actual cases, they did the same;

Another ask:
I connected with the user name password, now is when connected to that used in other databases, could it be the wrong user name password default database? I try to set the default database for the library of check on work attendance, the modified record will roll back...

CodePudding user response:

Want to do bad things! After the late early return can take attendance!

CodePudding user response:

Your SQL database is not the first store, just a long distance, why still through attendance software download it, then the real-time data is not exist here

CodePudding user response:

It should be attendance software to cover! With attendance record after you modify the software operating once know!

CodePudding user response:

Compare those records you so-called no rollback and what is the difference between the record of your own increase, or look at the schedule of attendance trigger or database has a JOB