INSERT INTO #Request.prefix_db_agency#.PatientRecordLock ( Patient_Id, Agency_ID, LockDate, LockedBy_ID ) VALUES ( #url.Patient#, #session.AgencyID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) UPDATE #Request.prefix_db_agency#.PatientRecordLock SET UnlockDate = #CreateODBCDateTime(Now())#, UnLockedBy_ID = 2623, Downloaded = 1 WHERE PatientRecordLock_ID = #url.PatientLock#