Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Count??
Message
De
07/08/2009 04:46:01
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
07/08/2009 04:35:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01416689
Message ID:
01416692
Vues:
67
You are addicted. (^.^)

Basically I agree with you. But the originator of this thread mixed up records with cursors so I tried to keep it simple.

there are numerous ways like
	create cursor Schnaps;
	(	a	c(1), ;
		b	c(1),; 
		c	c(1) ;
	)
	insert into Schnaps values ('', 'x', 'y')
	insert into Schnaps values ('', 'x', 'y')
	insert into Schnaps values ('a', 'x', 'y')
	insert into Schnaps values ('b', 'x', 'y')
	insert into Schnaps values ('c', 'x', 'y')
	
	select count(*)  as nCnt;
		from Schnaps ;
		into cursor SchnapsTmp;
		where empty(a)

               select Schnaps
	
	&& report cursor = Schnaps, use SchnapsTmp.nCnt as field in summary
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform