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

[Kathy Anderson <AndersoK@ROTARYINTL.ORG>]

        Does the ps_bas_sched table have any data in it?  If the select in
your list_customers procedure doesn't return rows, nothing gets printed in
the body of a report page, therefore no heading and no footing . . . no .lis
file.

        You might want to try adding some code to verify a row is returned
and print a message if nothing is printed.

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

        if #counter=0
           print 'No data . . . ' (+1,1)
        end-if

        end-procedure


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