[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

No Subject



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.

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}"



thanks


--
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.
---------------------------------------------------------------------------