Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select top N
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Select top N
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01000762
Message ID:
01000762
Vues:
66
Hi everybody,

Do you know why this code
* Get the unassigned accounts
	SELECT TOP m.lnNumAccounts TRANS.cTrans_Pk, ;
		Trans_Employees_Queues.cTrans_Employees_Queues_Pk, 0 AS iAssigned, ;
		SPACE(16) AS cCommission_Owner_UsGrLink_fk, ;
		SPACE(16) AS cqueue_names_fk ;
		FROM mmVisCollect!TRANS INNER JOIN mmVisCollect!Trans_Employees_Queues ;
		ON TRANS.cTrans_Pk = Trans_Employees_Queues.cTrans_fk ;
		WHERE ISNULL(Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk) ;
		AND Trans_Employees_Queues.cqueue_names_fk = m.lcQueue_Names_Fk ;
		ORDER BY TRANS.tDate_Received ;
		INTO CURSOR curAccounts READWRITE
would return only 48 records when lnNumAccounts = 180?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform