Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable view name - what's my best approach here?
Message
De
02/02/2005 05:04:51
 
 
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:
00982978
Vues:
18
>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)
>
Hi Nadya, why this complexity ?
if you rename to a static name the dynamic name the query is more readable.
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 cTempResult
Fabio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform