you will have to log into the database execute a querie
select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where user_name = '<Enter User Name>');
If you run it and you get 1 as a result then
For all variables in the scripts below you are required to replace the variable (indicated by the <> symbols) with an actual variable. The greater than and less than signs should not be present in after the variables are populated.
Example:
<Enter User Name> becomes JohnDoe
<Session Id> becomes 1234
1. Query the USESSION table for the users 'session_id':
select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where user_name = '<Enter User Name>');
2. Delete the users records in the table UPKLIST (Does not apply for SQL Lite):
Delete from UPKLIST where session_id = <session_id>;
3. Delete the users records in the table PROJSHAR:
Delete from PROJSHAR where session_id = <session_id>;
4. Delete the users records in the table USESSION:
Delete from USESSION where session_id = <session_id>;
Thank you Zoltan! We will
Thank you Zoltan! We will give this a try.
is you are using SQL then you
is you are using SQL then
you will have to log into the database execute a querie
select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where user_name = '<Enter User Name>');
If you run it and you get 1 as a result then