Re: Why isn't the "LIS" file being produced?

[Bill Winkfield <bwinkfield@GIA.EDU>]

As stated previously, your problem may be that there aren't any records in
the table. You could modify your code as follows to include a record count,
and verify it in your sqr log.

begin-procedure list_customers
let #recCount = 0

begin-select
sched_id (,1)
descr (,32)
!   position(+1)

        let #recCount = #recCount + 1

from ps_bas_sched
end-select

show #recCount

end-procedure

-----Original Message-----
From: anand9999@MY-DEJA.COM [mailto:anand9999@MY-DEJA.COM]
Sent: Friday, August 25, 2000 2:03 PM
To: SQR-USERS@list.iex.net
Subject: Why isn't the "LIS" file being produced?


Hi,

I've written the following test SQR script, but see no LIS file produced
after the script is executed.  FYI, the table "ps_bas_sched" does exist
within an Oracle database.

Does anyone have an idea why no LIS file is being produced?  Is there
something wrong with the program?

Thanks.

-- A.D.

BEGIN SQR SCRIPT

begin-program
        do list_customers
end-program

begin-heading 4
        print 'Name' (1) center
        print 'Sched ID' (3,1)
        print 'Description' (,32)
end-heading

begin-footing 1
        page-number (1,1) 'Page '
        last-page () ' of '
end-footing

begin-procedure list_customers
begin-select
sched_id (,1)
descr (,32)
   position(+1)
from ps_bas_sched
end-select
end-procedure

END SQR SCRIPT


--== Sent via Deja.com http://www.deja.com/ ==--
Before you buy.