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)>
lcQS = "v_QuickSearch" >SELECT &lcQS..*,; > IIF (EMPTY (&lcQS..cResolution_Codes_Fk) OR ISNULL (&lcQS..cResolution_Codes_Fk),; > &lcQS..cStatus_Codes_Fk,; > &lcQS..cResolution_Codes_Fk) AS cVisCodes_Fk,; > Employee_queue_schedules.cemployee_queue_schedules_pk,; > USERS.cUserID; > FROM (lcQS); > INNER JOIN mmVisCollect!Trans_employees_queues; > ON &lcQS..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 cTempResultHTH
>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 v_QuickSearch ; >> 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 cTempResult>But now I want to be able to use variable instead of v_QuickSearch, e.g. it could be v_QuickSearch or v_QuickSearch_PolicyNumber or v_QuickSearch_Medicaid. Would you please help me to constract such a statement? Do you think, it's better to build the whole lcSQL as a variable?