[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Why isn't the "LIS" file being produced?
- Subject: Why isn't the "LIS" file being produced?
- From: anand9999@MY-DEJA.COM
- Date: Fri, 25 Aug 2000 14:03:12 -0700
- Organization: My Deja Email (http://www.my-deja.com:80)
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.