2008 Feb 07 9:31 AM
Hi guyz,
i dunno if im in right place for this question,
my question is :
at the moment in my program there is a statement,
provide * from p0002 between qppnp-begda and qppnp-endda.
now i wan it like
greater than or equal to qppnp-begda
with out chaging qppnp-endda..
advise
regards
2008 Feb 07 9:40 AM
Change the statement as followng -
provide * from p0002 where begda >= qppnp-begda
between qppnp-begda and qppnp-endda.
Hi guyz,
i dunno if im in right place for this question,
my question is :
at the moment in my program there is a statement,
provide * from p0002 between qppnp-begda and qppnp-endda.
now i wan it like
greater than or equal to qppnp-begda
with out chaging qppnp-endda..
advise
regards
2008 Feb 07 9:37 AM
The statement itself gives U records between begda and
endda ..
It means all the records with the following condition would be
fetched ..
p0002-endda >= qppnp-begda and
p0002-begda <= qppnp-endda.
U cannot change the CONDITION in provide ...
2008 Feb 07 9:40 AM
Change the statement as followng -
provide * from p0002 where begda >= qppnp-begda
between qppnp-begda and qppnp-endda.
2008 Feb 07 9:51 AM
amit thanks for your reply
provide * from p0002 where begda >= qppnp-begda
between qppnp-begda and qppnp-endda.
but why we using "between qppnp-begda and qppnp-endda" agen...
do i get the right output....
i wanna change BEGDA into greater than or equal to
but ENDDA shud be same...
am i confusing u??
sorry if i do
regards