Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable view name - what's my best approach here?
Message
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:
00982843
Vues:
23
This message has been marked as the solution to the initial question of the thread.
What about:
lcFrom  = 'v_QuickSearch'
SELECT myView.*, ;
		IIF(EMPTY(myView.cResolution_Codes_Fk) OR ;
		ISNULL(myView.cResolution_Codes_Fk), ;
		myView.cStatus_Codes_Fk, ;
		myView.cResolution_Codes_Fk) AS cVisCodes_Fk, ;
		Employee_queue_schedules.cemployee_queue_schedules_pk, USERS.cUserID ;
		FROM (lcFrom) as myView ;
		INNER JOIN mmVisCollect!Trans_employees_queues ;
		ON myView.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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform