Determining Number of records

[Deskin, Bob]

If you want to count records before doing standard file retrieval (i.e.
Find mode), declare the file a second time as a DESIGNER file with an
alias and do a WHILE RETRIEVING to count the records (LET temp = temp +
1). If you want to make sure that the counting doesn't interfere with
normal retrieval, give it a second open (assuming it's non-relational).

Bob Deskin              
Senior Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Jody Burgess
Sent: December 15, 2004 4:37 PM
To: powerh-l@lists.sowder.com
Subject: Determining Number of records
Importance: High


Hi;
  In QDesign, in an internal or designer procedure, I was wondering how
I can determine the number of records that would be returned after
issueing a file statement such as:

	file user_info detail close


Thanks
Jody Burgess ISP
Systems Analyst
Seward Consulting Ltd.
780.702.5103
jody.burgess@sewardconsulting.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.