Re: [sqr-users] comparing with zero's

["Prasanna Menta" <pmenta@umuc.edu>]

You should display the variables, second look for any spaces.
Hope this helps
Prasanna

chandrashekar patlolla wrote:
> 
> Hi ALL
> 
> i have two variables
> 1. temp which is number(7,6)
> 2. temp1 which is number(7,6)
> 
> and when i am doing this
> 
> if temp - temp1 = 0
> do xyz
> end-if
> 
> but the control is not going to the procedure xyz. Is that SQR does not 
>recognize the 0's
> if yes how.
> 
> Thanks in advance
> 
> Regards
> Chandra
> 
> 
> 
> "Sahani, Dev" <Dev.Sahani@fmr.com> wrote:
> Thanks for replying.
> The thing is that I have no control on the number of lines in the header, it
> is controlled by user input. So it maybe the case that the header is
> actually going beyond a whole page in some cases, causing this error...
> 
> I don't have a footer in the report, so looks like, that's not the reason I
> am getting this error.
> 
> I'm quite convinced that my header is overflowing. I'll try and prototype
> this with something simple to see if that's the case
> 
> Thanks,
> 
> Dév Rishi Sahani
> FESCo DB Systems
> Fidelity Investments
> 
> -----Original Message-----
> From: D Patel [mailto:dgpinfo@yahoo.com]
> Sent: Tuesday, November 18, 2003 10:15 PM
> To: sqr-users@sqrug.org
> Subject: Re: [sqr-users] BEFORE-PAGE, AFTER-PAGE procedures??
> 
> As per my observation this error will be generated
> only when you are trying to write something in Footer
> but you don't have enough-space in footer. So, it will
> try to write footer on the next page and hence the
> error get generated.
> To avoid this erro try to increase Footer size.
> 
> Thanks,
> D Patel
> 
> --- Jyotsna Nekkanti wrote:
> > Hi,
> >
> > I got the same error a while back. And I think it
> > has to do with either the number of lines in the
> > header or the co-ordinates in the body of the
> > report. Try decreasing them and see if that helps.
> >
> >
> >
> > "Sahani, Dev" wrote:
> > Hey All,
> >
> > I have a couple of SQR jobs that run fine most of
> > the times, but a few
> > instances fail, and I get the following error in the
> > Job factory Log:
> >
> > >>(SQR 5400) Second page write attempted while
> > writing current page.
> > >>Check BEFORE-PAGE, AFTER-PAGE procedures.
> >
> > Yeah the jobs are a little funky in the sense that
> > the header that comes on
> > the first page is dynamic, so I calculate the
> > position of first line based
> > on the number of lines used by the header
> > dynamically... Something like
> > this:
> >
> > Let #HeaderSpace = #HeaderSpace * 10 !Header Space
> > is the number
> > of lines taken up by the header (only on page one)
> > Add 10 to #HeaderSpace !To make sure that
> > the variable headerspace is > 0 for relative
> > positioning
> > !And if
> > enough room on the page, printing will start 10
> > points below the header
> >
> > If #HeaderSpace >= (#sqr-max-lines) !If the header
> > takes up the
> > entire page, start printing query results on page
> > two
> > New-Page
> > Else
> > Position (+#HeaderSpace ) !Else set print
> > position at #HeaderSpace
> > End-If
> >
> > Any clue of what might be happening here?
> >
> > Any help will be greatly appreciated.
> >
> > Thanks,
> > Dev Rishi Sahani
> > ________________
> > FESCo DB Systems
> > Fidelity Investments
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Protect your identity with Yahoo! Mail AddressGuard
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> ---------------------------------
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users