Is it possible to send SQL commands to SO to adjust a cashier time clock entries? If so what table would I need to be able to access time clock entries? Any direction would be greatly appreciated. I am using RMS 2.0155 SO and HQ 7 stores. I am looking to be able to setup a template sql command that would change and correct the wrong entries instead of giving Managers access to do it.
*This post is locked for comments
BTW, which time clock are you talking about? Is it legal to edit the timesheet settings of a third party software without rights?
I wouldn't try doing it to any software, moreover the time clock that we use gives all facilities to the users atleast in the admin access.
update timeclock set TimeOut = '11/22/2008 4:04:47' where id = '16'
This updates the SO database. As I am finding out there would be a lot a queries to find the exact record you need to adjust and maybe use a method of loging in remotely to change might be the better option for time saving. updating Hq might be the missing component.
Ok Timeclock is the table.
select * from timeclock where cashierID = '5' and TimeIn = '11/17/2008 9:08:43 AM'
I was trying to use the command to select the record I needed and it returns 0 rows. Is there something wrong with the syntax? No errors when I run it.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
