[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Nested begin-select blocks
- Subject: Nested begin-select blocks
- From: John Milardovic <milardj@SX.COM>
- Date: Thu, 5 Aug 1999 14:43:02 -0400
Hi all.
I'm writing a couple of reports that have nested begin-select blocks i.e..
begin-select
job_numbers
!for each job number call procedure to select job details
from
some_table
The details from each job number will make up individual *.lis files.
I was just wondering if this would cause a performance issue and whether I
would be better off joining the two select blocks together and breaking on
job number to print out the individual details. In terms of readability and
ease of programming I find the nested route easier to develop.
I would appreciate it if anyone could give me some advice (in regards to
performance) based on prior experience.
Thanks.
John Milardovic