Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.02 » View Incident Report |
Serious |
Reported By: Hedley Muscroft Reported On: 3/26/2009 For: Version 2.02 Build 10 |
SCRIPT () BEGIN EXECUTE IMMEDIATE 'update link set ref_visnote_id=null where ref_visnote_id in (select id from visnote where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from visnote where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'update link set ref_visnote_id=null where ref_visnote_id in (select id from visnote where sess_id in (select id from sess where cas_id=1260309130314523789))'; EXECUTE IMMEDIATE 'delete from visnote where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from custom_session_fields where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from custom_case_fields where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'update link set ref_fileatt_id=null where ref_fileatt_id in (select id from fileatt where sess_id in (select id from sess where cas_id=1260309130314523789))'; EXECUTE IMMEDIATE 'delete from fileatt where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from custom_patient_fields where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'update link set ref_img_id=null where ref_img_id in (select id from img where sess_id in (select id from sess where cas_id=1260309130314523789))'; EXECUTE IMMEDIATE 'delete from img where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'update app set sess_id=null where sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'update link set ref_sess_id=null where ref_sess_id in (select id from sess where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from sess where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'delete from custom_session_fields where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'delete from custom_case_fields where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'update link set ref_fileatt_id=null where ref_fileatt_id in (select id from fileatt where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from fileatt where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'delete from custom_patient_fields where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'update link set ref_img_id=null where ref_img_id in (select id from img where cas_id=1260309130314523789)'; EXECUTE IMMEDIATE 'delete from img where cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'update link set ref_cas_id=null where ref_cas_id=1260309130314523789'; EXECUTE IMMEDIATE 'delete from cas where id=1260309130314523789'; END
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |