Re: debug sqr error?

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

Thanks Rachael, I'll check it out, but again it runs fine on the client and
the error only occurs when running on the server, which is what I don't
understand.

ac

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Rachael Beatty
Sent: Tuesday, October 02, 2001 3:58 PM
To: SQR-USERS@list.iex.net
Subject: Re: debug sqr error?





I have seen this before, but cannot remember what it was.  Validate that you
have all your if's and end-ifs and also all the begin procedure and
end-procedure.
Lastly, validate that you do not have anything in the first column of your
sql statements.

Rachael

> -----Original Message-----
> From:   "Allen Cunningham" <allen.cunningham@SONOMA.EDU>@INTERNET
> Sent:   Tuesday, October 02, 2001 3:46 PM
> To:     SQR-USERS@list.iex.net
> Subject:     Re: debug sqr error?
>
>
> Actually the error is occuring on the next to last line of the sqr, just
> before the last comment line, see below. Also, this sqr runs fine on the
> client, but bombs on the server.
>
> #Include 'songetdb.sqc'   !Custom - Get Database Name (THIS IS LINE 1612)
> !---------------------------- End of Program --------------------------
>
> Also, so anytime I see an error on a line number, it will be pointing to
> the
> sqr itself? Not to included sqc code that has been brought in to the sqr?
>
> ac
>
>
> -----Original Message-----
> From: Discussion of SQR, Brio Technology's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez
> Sent: Tuesday, October 02, 2001 3:31 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: debug sqr error?
>
>
> Allen, when the error is in the SQC, it actually tells you.  I'd tell you:
> 'error in the include file...  line ....'
>
> The error you're getting is because you have a procedure that does not
> begin
> or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..."
> check your code on that line (1612) and make sure you do have those
> keywords
> if it is the beginning or end of a procedure.
>
> Hope that helps!
>
> Good luck!
>
> Laura.
>
> > -----Original Message-----
> > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU]
> > Sent: Tuesday, October 02, 2001 3:11 PM
> > To:   SQR-USERS@list.iex.net
> > Subject:      debug sqr error?
> >
> > sqr version 4.3.4
> > database Oracle
> >
> > I get the following error when running sqr:
> > Error on line 1612:
> >    (SQR 4702) Line found outside paragraph.
> >
> > Since SQC's are included how can I know if this is the correct line
> where
> > the error is occuring??
>

(See attached file: C.DTF)