Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable view name - what's my best approach here?
Message
 
 
À
01/02/2005 15:30:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
00982834
Message ID:
00982841
Vues:
26
I found solution in one of Sergey's messages:
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 cTempResult
HTH
>
>>I have the following command:
>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?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform