Re: debug sqr error?

[laura lopez <laura.lopez@TRINET.COM>]

Allen, according to my SQR book that error:
(SQR 4702) Line found outside paragraph - means the following:
"All commands must be within BEGIN-... END-statements. Correct the source
code".

Sometimes it is true that it may have an error in the main sql so make sure
that is ok.

Make sure the versions you are testing on the client and on the server is
the exact same version.  I know it may sound silly but it's happened before!


Good luck!

LL
> -----Original Message-----
> From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU]
> 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??