>>SELECT DISTINCT Employee_queue_activity.cemployee_queue_activity_pk,; >> Employee_queue_activity.ctrans_employees_queues_fk,; >> Employee_queue_activity.inumber_of_items_worked_count,; >> Employee_queue_activity.iminutes_per_account_count,; >> Employee_queue_activity.istatus_changes_count,; >> Employee_queue_activity.iresolved_accounts_count,; >> Employee_queue_activity.irequeued_accounts_count,; >> Employee_queue_activity.tentered_date,; >> Employee_queue_activity.centered_user,; >> Employee_queue_activity.tlast_updated_date,; >> Employee_queue_activity.clast_updated_user; >> FROM ; >> MMVISCOLLECT!TRANS_EMPLOYEES_QUEUES ; >> INNER JOIN MMVISCOLLECT!EMPLOYEE_QUEUE_ACTIVITY ; >> ON Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_activity.ctrans_employees_queues_fk ; >> INNER JOIN MMVISCOLLECT!QUEUE_NAMES ; >> ON Queue_names.cqueue_names_pk = Trans_employees_queues.cqueue_names_fk ; >> INNER JOIN MMVISCOLLECT!EMPLOYEE_QUEUE_PROFILES ; >> ON Queue_names.cqueue_names_pk = Employee_queue_profiles.cqueue_names_fk; >> WHERE Queue_names.cqueue_names_pk LIKE ( ?VP_CQUEUE_NAMES_PK ); >> AND ( Employee_queue_activity.tentered_date BETWEEN DATE() AND DTOT(DATE()+1)-1; >> AND Trans_employees_queues.ccommission_owner_usgrlink_fk = ( ?VP_CUSGRLINK_FK ) ) >>>>
>1: doesn't put database into the SET("DIRECTORY"), > >2: SET PATH TO <EMPTY> > >3: when you want change the database context: > - close all datasessions > - reset the databases context >*** RESET >CLOSE DATABASES ALL >CLOSE TABLES ALL >In other words, you're suggesting to exclude database from the path. BTW, the database is included in the project (it's excluded, but it's part of the project). This seems like the easiest thing to implement and may solve our problems. I'll discuss this idea with my colleagues.