>lcvName = "v_QuickSearch" > >TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 7 >SELECT <<m.lcvName>>.*, >IIF(EMPTY(<< m.lcvName >>.cResolution_Codes_Fk) OR >ISNULL(<< m.lcvName >>.cResolution_Codes_Fk), ><<m.lcvName>>.cStatus_Codes_Fk, ><<m.lcvName>>.cResolution_Codes_Fk) AS cVisCodes_Fk, >Employee_queue_schedules.cemployee_queue_schedules_pk, USERS.cUserID >FROM <<m.lcvName>> >INNER JOIN mmVisCollect!Trans_employees_queues >ON <<m.lcvName>>.cTrans_PK = Trans_employees_queues.ctrans_fk >INNER JOIN mmVisCollect!usgrlink >ON Trans_employees_queues.ccommission_owner_usgrlink_fk = usgrlink.cusgrlink_pk >INNER JOIN mmVisCollect!Employee_queue_schedules >ON Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_schedules.ctrans_employees_queues_fk >INNER JOIN mmVisCollect!USERS >ON USERS.iid = usgrlink.iuserid >WHERE Trans_employees_queues.iactive_flag = 1 >AND Employee_queue_schedules.iactive_flag = 1 >INTO CURSOR cTempResult >ENDTEXT >lcSQL = CHRTRAN(lcSQL, CHR(13)+CHR(10),"") >=MESSAGEBOX(lcSQL) >Hi Nadya, why this complexity ?
lcQS = "v_QuickSearch" SELECT v_QuickSearch.*,; IIF (EMPTY(v_QuickSearch.cResolution_Codes_Fk) OR ISNULL (v_QuickSearch.cResolution_Codes_Fk),; v_QuickSearch.cStatus_Codes_Fk,; v_QuickSearch.cResolution_Codes_Fk) AS cVisCodes_Fk,; Employee_queue_schedules.cemployee_queue_schedules_pk,; USERS.cUserID; FROM (m.lcQS) AS v_QuickSearch; && or macro or [varstring] or TEXT TO INNER JOIN mmVisCollect!Trans_employees_queues; ON v_QuickSearch.cTrans_PK = Trans_employees_queues.ctrans_fk; INNER JOIN mmVisCollect!usgrlink; ON Trans_employees_queues.ccommission_owner_usgrlink_fk = usgrlink.cusgrlink_pk; INNER JOIN mmVisCollect!Employee_queue_schedules; ON Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_schedules.ctrans_employees_queues_fk; INNER JOIN mmVisCollect!USERS; ON USERS.iid = usgrlink.iuserid; WHERE Trans_employees_queues.iactive_flag = 1; AND Employee_queue_schedules.iactive_flag = 1; INTO CURSOR cTempResultFabio