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

["Fay, Brannon" <brannon.fay@PAETEC.COM>]

Also make sure you don't have -NOLIS set in your command line or SQRFLAGS
environment variable.

Just a thought...

Brannon J. Fay
Software Engineer
PaeTec Communications, Inc.
(864) 268-9194 work
(864) 217-1394 pager



-----Original Message-----
From: Pragya Chandra [mailto:pchandra@FASTENAL.COM]
Sent: Friday, August 25, 2000 5:32 PM
To: SQR-USERS@list.iex.net
Subject: Re: Why isn't the "LIS" file being produced?


Maybe check to see if there is any data in the table.  If no detail lines
are printed, the program won't print  the heading either.

> -----Original Message-----
> From: anand9999@MY-DEJA.COM [SMTP:anand9999@MY-DEJA.COM]
> Sent: Friday, August 25, 2000 4: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.