Re: debug sqr error?

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

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

Arun - On the server all sqr's and sqc's are in the same dir. I am starting
to think it's a problems with our ASP who hosts the databases at a remote
location, and they might not have set things up correctly. I am sending off
a help desk ticket to check on it. Thanks for the response.

ac

Allen,
Did you make sure that all the Search paths are fine
on the Server. If the search path to include file are
missing you would get this error. And you wont get
this error on your client m/c where the search path
are defined properly.

Hope this helps
--- Allen Cunningham <allen.cunningham@SONOMA.EDU>
wrote:
> 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)


__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com