on 12-22-2010 9:43 AM
Hi,
I have the following fields
Basic Start Date:12/12/2010
Basic End Date:14/12/2010
I need to use these fields for retrieving a production date from plaf table.
The problem is both these dates needs to be the low and high of Production date
Say for Eg., if the production date is p_date,
p_date-low = basic start date
p_date-high = basic end date
Since I can't declare p_date as ranges in proxies, how do i achieve this result.
My select query would be such that
select * from plaf where prod_date in p_date. Something like this.
This the way you do for a ranges;
*- Create Date
ra_cdt type range of <table Name>-erdat,
rw_cdty_line like line of ra_cdt.
rw_cdty_line-sign = 'I'.
rw_cdty_line-option = 'BT'.
rw_cdty_line-low = from .
rw_cdty_line-high = to.
append rw_cdty_line to ra_cdt.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.