Counting amount of records in quick

Rohde Dirk (Van) Dirk.Rohde@vpgroup.com
Fri, 19 May 2000 07:05:33 -0700


If you are using a relational database, you can use an embedded SQL command
("select count(0) from <file>"), otherwise I think you need to use brute
force - a "while retrieving" loop with a counter.  If you don't need the
exact count, put a break once your counter is greater than 5000.

-----Original Message-----
From: Bourchi, H. [mailto:bourchih@unive.nl]
Sent: Friday, May 19, 2000 6:53 AM
To: 'powerh-l@lists.swau.edu'
Subject: Counting amout of records in quick


> Goed day,
> 
> Quick question : (I am using ver. (7.10.F2) on Open vms)
> I need to run a screen only if amout of one of my data file greather then
> 5000 is. 
> Somthing like this :
> 
> 	If amout of file > 5000
> 	then run screen ... 
> 	
> My question is how can I count amout of a data file in quick.
> 
> thanks,
> Hamid Bourchi
> 
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.