Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need Assistance With SQL Command
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Need Assistance With SQL Command
Divers
Thread ID:
01305489
Message ID:
01305489
Vues:
45
I have an app that has this query. Note the ASCAN() command:
SELECT rcm_pk, cmt_custname, rlc_number; 
	FROM RailComp, RailCars, CustMast;
	WHERE rcm_rlc_fk = rlc_pk AND;
		  rcm_custcode = cmt_custcode AND;
		  NOT DELETED() AND;
		  NOT rlc_final_bill AND;
		  rlc_rectype = "R"  AND;
		  ASCAN(laCustCode,custmast.cmt_custcode,1) > 0;
	ORDER BY rcm_custcode, rlc_number, rcm_compdesc;
	INTO CURSOR WouSel;
I tried to change it to use a dynamically created cusstomer list, but I get a 'Line is too long' error when I
select all customers:

SELECT rcm_pk, cmt_custname, rlc_number; 
	FROM RailComp, RailCars, CustMast;
	WHERE rcm_rlc_fk = rlc_pk AND;
		  rcm_custcode = cmt_custcode AND;
		  NOT DELETED() AND;
		  NOT rlc_final_bill AND;
		  rlc_rectype = "R"  AND;
		  INLIST(rcm_custcode, 'ABCDE','ABL24','ACA30','ACM17');
	ORDER BY rcm_custcode, rlc_number, rcm_compdesc;
	INTO CURSOR WouSel;
Is there a way to do this with a join?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform