Re: new-page error under strange circumstances

[Ray Ontko <rayo@ONTKO.COM>]

Mainoo,

Is it possible that your begin-heading calls a procedure
which executes a query which does some printing?  If this
printing goes off the bottom of the page and causes a
new page to occur, then you will get the error you describe.
This may be related to the changes you're making if they
cause many more rows to be returned by the query.

Hope this helps.  It's hard to tell without looking at the
program.  If you can't show us the whole thing, try trimming
it down to the smallest possible program that has the problem.
In doing so, you may discover the cause of the problem.  If not,
it will help the rest of us focus on a smaller piece of code.
Good luck.

Ray

> I have a program that generates the following error:
>
>
>
> (SQR 5004) Attempt to execute the New-Page command while processing the
>  Begin-Heading section.
>
> The problem is it only does so after I have amended a select query. Given that
> there seems to be no connection between the select query and the locations
> where new-page is invoked i don't understand how this error could possibly
> occur. The only difference between the case where it works and the case where
> it doesn't is shown below (output from diff). I haven't included the program
> (its a long story) but has anyone else come across this particular error under
> such strange circumstances? I'm running version 3.0.X.
>
>
> Thanks
>
> diff gwseq001.sqr.1 gwseq001.sqr.2
> 250c250
> < where opertype = 'SELL' and capacity <> 'P' and processStatus =
>  "[$curr_status]"
> ---
> > where opertype = 'SELL' and capacity <> 'P' and processStatus =
>  "[$curr_status]" and trdDate > "{begin_date}" and trdDate < "{end_date}"
> 254c254
> < where opertype = 'BUY' and capacity <> 'P'  and processStatus =
>  "[$curr_status]"
> ---
> > where opertype = 'BUY' and capacity <> 'P'  and processStatus =
>  "[$curr_status]" and trdDate > "{begin_date}" and trdDate < "{end_date}"
>
>
>
> --
> Mainoo Smith
> System Development & Support
> Nomura Research Institute Europe Ltd
> ---------------------------------------------------------------------------
> Email mainoo.smith@nomura.co.uk
> ---------------------------------------------------------------------------
> Any views expressed are mine and not those of Nomura plc.
> ---------------------------------------------------------------------------
>

----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/