Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Logical database

Former Member
0 Likes
541

Hi there. I'm using ADA logical database to perform data selection. After I select data from certain table, I have to restrict the result with another selection. How can I select the max value from table ANEP?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
520

Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

4 REPLIES 4
Read only

Former Member
0 Likes
520

u get data to variable/internal table. now loop this and using another data selection u can restrict the values.

Read only

Former Member
0 Likes
521

Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Read only

amit_khare
Active Contributor
0 Likes
520

Hi,

You may go like this -

Get <struct/tab>.

.

.

if tab-field <= v_value. (to select values greater than v_value.

reject.

End-of-selection.

Regards,

Amit

Read only

Former Member
0 Likes
520

Thanks.